Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Access Denied or Server not Found
Message
De
31/03/2009 17:14:18
Greg Rowe
Memphis Police Department
Memphis, Tennessie, États-Unis
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Sécurité
Titre:
SQL Access Denied or Server not Found
Versions des environnements
SQL Server:
SQL Server 2000
Divers
Thread ID:
01392502
Message ID:
01392502
Vues:
86
I am not able to connect to a SQL server instance that running on a Windows 2003 clustered server. There is another SQL instance running on the same cluster which I can successfully access. I even attempted to access the SQL server from the physical server. When I open enterprise manager and expand the SQL server group the SQL servers displays with a green arrow indicating the SQL server services are running. However, when I click the server I need to access to expand the server's databases, DTS, management, etc, I receive the following error message: "Unable to connect to server myservername: Server: Msg 17, Level 16, State 1 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL server does not exist or access denied." I opened the SQL server registration properties and verifed the settings. I changed the connection properties from SQL to Windows and received the same error. I verified that I am using the correct sa SQL account and password. I even added my network account to the SQL administrators group for windows authentication. I logged into the server with the server's local administrator account and received the same error message. I can stop and start the SQL server through enterprise manager. I have the same problem when I attempt to use query analyzer. I can do everything I need with the other SQL instance that is running in the same cluster.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform