Changed login method causing errors to databases

[Tony Girgenti]

Hello,

I have Microsoft SQL Server Management Studio 10.0.1600.22
((SQL_PreRelease).080709-1414 ) installed on Windows XP SP3 computer.

I used to logon to the machine as a local user with the administrator user
id,. I never had a problem using existing and creating new databases.

I have since had the requirement to join this computer to a domain and logon
to the domain as domainname\administrator. Since i started that, i cannot
open or create any databases.

When i attempt to open a database in SSMS, it gives the message "The
database LakesideOfficeSystemsData is not accessible. (ObjectExplorer)".

If i try to create a database, it gives the message:

TITLE: Microsoft SQL Server Management Studio
------------------------------
Create failed for Database 'TestDB'. (Microsoft.SqlServer.Smo)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.2531.0+((Katmai_PCU_Main).090329-1015+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
------------------------------
CREATE DATABASE permission denied in database 'master'. (Microsoft SQL
Server, Error: 262)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.1600&EvtSrc=MSSQLServer&EvtID=262&LinkId=20476

If i try to look at the properties for a datasbase, it gives this message:

TITLE: Microsoft SQL Server Management Studio
------------------------------
Cannot show requested dialog.
------------------------------
ADDITIONAL INFORMATION:
Cannot show requested dialog. (SqlMgmt)
------------------------------
Property Collation is not available for Database
'[LakesideOfficeSystemsData]'. This property may not exist for this object,
or may not be retrievable due to insufficient access rights.
(Microsoft.SqlServer.Smo)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.2531.0+((Katmai_PCU_Main).090329-1015+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.PropertyCannotBeRetrievedExceptionText&EvtID=Collation&LinkId=20476

I can open the system databases, but not the others.

Any help in resolving this problem would be gratefully appreciated.

Thanks,
Tony

[Dan Guzman]

> I used to logon to the machine as a local user with the administrator user
> id,. I never had a problem using existing and creating new databases.
>
> I have since had the requirement to join this computer to a domain and
> logon
> to the domain as domainname\administrator. Since i started that, i cannot
> open or create any databases.

It looks like your new user account is not a member of the SQL Server
sysadmin role. Try logging into your PC with the local account you used
previously and connect via SSMS. You should then add your domain account
login to the sysadmin role:

CREATE LOGIN [domainname\administrator] FROM WINDOWS;
EXEC sp_addsrvrolemember 'domainname\administrator', 'sysadmin';

Log back in with your domain account and you will have sysadmin privileges.

--
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

"Tony Girgenti" <tony(nospam)@lakesideos.com> wrote in message
news:1FEE88A5-279F-4E1D...@microsoft.com...

[Tony Girgenti]

Thanks Dan. That did resolve the issue.

I'm trying to open the BeerHouse database in a VS2008 project. When i run
the project, it gives the error:
Cannot open database "TheBeerHouseVB" requested by the login. The login
failed.
Login failed for user 'LAKESIDEOFFICES\Administrator'.

If this new problem is not within your realm, i will gladly ask on CodePlex.

Thanks,
Tony

[Erland Sommarskog]

Tony Girgenti (tony(nospam)@lakesideos.com) writes:
> I'm trying to open the BeerHouse database in a VS2008 project. When i run
> the project, it gives the error:
> Cannot open database "TheBeerHouseVB" requested by the login. The login
> failed.
> Login failed for user 'LAKESIDEOFFICES\Administrator'.

If you connect to SSMS as LAKESIDEOFFICES\Administrator, and you emit
"USE TheBeerHouseVB", what happens?

> If this new problem is not within your realm, i will gladly ask on
> CodePlex.

They are not likely to help you with configuration issues on your machine.

--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Tony Girgenti]

Hello Erland.

By "Emit", I have to assume you mean execute a query. I did that and got
this error:
Msg 911, Level 16, State 1, Line 1
Database 'TheBeerHouseVB' does not exist. Make sure that the name is entered
correctly.

Thanks,
Tony

"Erland Sommarskog" wrote:

> .
>

[Erland Sommarskog]

Tony Girgenti (tony(nospam)@lakesideos.com) writes:
> By "Emit", I have to assume you mean execute a query. I did that and got
> this error:
> Msg 911, Level 16, State 1, Line 1
> Database 'TheBeerHouseVB' does not exist. Make sure that the name is
> entered correctly.

Well, it is quite difficult to connect to a database that does not
exist.

[Tony Girgenti]

Hello Erland.

I was able to resolve this issue from here:
http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/

I think the port setup did it for me.

Thanks for all of your help.
Tony

"Erland Sommarskog" wrote:

> .
>