i have installed sql server 2008 r2 in my DELL laptop with windows 7 OS. I have chosen default instance MSSQLSERVER while installing and Server name as
gowtham. After installing i have restored a database backup in the name ADMIN. when iam trying to connect to ADMIN database, i am getting an error message "Unable to connect database -Admin". I have tried by switching of fire wall also.
i am trying to database in the local system,not through network. can any one help in this.....
View Complete Post
I am receiving the following error when I try to connect to my new SQL Server 2008 R2 machine:
Msg 18452, Level 14, State 1, Server <server name>, Line 1 Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
I'm running the following command to test the connection:
sqlcmd -S<Server Name> -E -Q"Select @@servername"
On the server I'm getting the following from the SQL Server logs
03/31/2011 20:31:58,Logon,Unknown,Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. [CLIENT: 172.20.146.95]
03/31/2011 20:31:58,Logon,Unknown,Error: 18452<c/> Severity: 14<c/> State: 1.
03/31/2011 20:31:58,Logon,Unknown,SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: 172.20.146.95]
03/31/2011 20:31:58,Logon,Unknown,Error: 17806<c/> Severity: 20<c/> State: 2.
I just installed SQL Server 2008 Management studio Express on my Vista machine. i tried connecting to local machine using :.\sqlexpress, (local)\sqlexpress, or .\SQLExpress, MyPCNAME\SQLExpressnothing is working, getting this error:-----------------------------Cannot
connect to PC-NAME\SQLEXPRESS. A network-related or instance-specific
error occurred while establishing a connection to SQL Server. The server
was not found or was not accessible. Verify that the instance name is
correct and that SQL Server is configured to allow remote connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating