![]() ![]() The only way to do anything in single-user mode (it appears) ![]() In effect, simply opening Management Studio in single-user mode was causing an administrator to connect. (Microsoft SQL Server, Error: 18461)." What the error utterly fails to tell you is thatĪny connection to single-user mode qualifies as an administrator connection. Log into Management Studio and the user you created should be listed under logins with the credential of "sysadmin."īefore this, I was getting the error " Only one administrator can connect at this time. ![]() Now restart it from services the normal way. now Ctrl C the single-user mode from the first cmd window to kill SQL Server. sp_addsrvrolemember 'domain\user', 'sysadmin'ĥ. "c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Binn\sqlservr.exe" -m -s SQLEXPRESSĪ. open cmd window (as admin) and run single-user mode as local admin with this command: I'm now having a problem importing data (more on that later), but at least I can create a database. Do I need to assign permissions to this folder somehow?īear in mind this will be a remote install and the user expects it work flawlessly. The database must be installed in the ProgramData folder. How is it possible to scrip this? there is no documentation i can find. This thread talks about converting the server to single user mode before adding a login It fails on srv.CreateDatabase with error message "permission denied in database MASTER" I used SMO to add the current user (who is a Windows Administrator) as a Login to the SQL Express server.ĭim l As Login = New Login(srv, My.User.Name) On test SQLExpress installs OKĪfter the application is installed it must create and install a database using a mixture of SMO and Scripting. I have created a setup application with SQLEXpress 2008 as a prerequisite. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |