March 16, 2009 at 4:24 pm
In my office i have 2 NT Ids, one is general and another is prj-general.
I have access to a database, with general login.
By using Microsoft SQL Server Management Studio(SQL Server 9.0.3282), File -> Connect to Server
I enter the server name and click on the Windows Authentication and Click on "Ok" button. I will be able to login to the db.
When i login to a machine(machine-2) with my prj-general id and try to open the same db using the Windows authentication as above, i am getting the error as below
Error Number: 18456
Severity: 14
State: 1
Line Number: 65536
When i login to a machine(machine-2) with my prj-general id and then select SQL Server authentication. Provide my general user id and password. and clicked Ok button
I am getting the error as below
Error Number: 18456
Severity: 14
State: 1
Line Number: 65536
Can some one help me how to get rid of this problem.
I need to write a web application, which i need to host on this second machine(machine-2), using either of my NT ids.
Suggest me some way.
I dont have any admin rights on the DB. I am just a simple user.
March 23, 2009 at 11:41 pm
Hmm State 1 usually means you are running in Single user mode...
But this seems a bit different .. you second login can you please check it has permissions on database and server ?
SELECT *
FROM sys.server_principals
SELECT *
FROM sys.database_principals
And paste the results of those queries here?
Also can you please paste results of sp_configure results here..
Thanks.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply