June 27, 2003 at 7:43 am
Windows 2000 Advanced Server
SQL Server 2000 Enterprise Edition
Service Pack 3
After normal restore of our database from production server to a test server (Compaq DL380 cluster) I have lost connection to a virtual test server KORMORAN.
SQL Server Service Manager is working fine (running on virtual server), services are up and running but I can not connect to SQL registration.
Cluster administrator shows that all resources are online.
Enterprise Manager message:
A connection could not be established to KORMORAN.
Reason: Cannot open user default database. Login failed. Please verify SQL Server is running and check your SQL server registration properties.
SQL Query Analizer message:
Server: Msg 4064, Level 16, State 1
[Microsoft][ODBC SQL server driver][SQL Server] Cannot open user default database.
I'm shure that my windows authentication is OK. Futhermore, I have tried to use SA account with right password but without success.
How can I establish back connection to virtual server?
Thanks
bgreg
June 27, 2003 at 8:16 am
July 1, 2003 at 6:01 am
Booth articles describe use of isql or osql utilities. Booth utilities need connection to database, the connection that I don’t have.
These are commands and error messages:
command: isql –Usa –P<right_password> -P<server_name>
message:Msg: 18452, Level 14, State 1:
Login failed for user “sa”. Reason: Not associated with a trusted SQL Server connection.
DB-Library: Login incorrect
I have also tried to log in as local administrator (witch is member of System Administrators server role) and then to change password:
command: osql –E –Q “exec sp_password null,’new_password’,’sa’”
message: DB-Library: Unable to connect: SQL server is unavailable or does not exist. Unable to connect: SQL server not exist or network access denied.
Net-library error 10049: ConnectionOpen (Connect())
bgreg
July 1, 2003 at 6:10 am
The error message generated when you tried to connect as 'sa' looks like the server is set up for Windows authentication only, not SQL Server and Windows authentication.
The second attempt using Windows authentication doesn't seem to specify a server name
July 10, 2003 at 5:46 am
yep, got mixed mode.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply