Microsoft SQL Server
--
Questions
--
Followers
Top Experts
First I installed a named Instance of MSDE (Instance1). After installing and rebooting the server I attempted to register the instance using Enterprise Manager on my development workstation. I received the error message "SQL Server does not exist or access denied".
Also after rebooting the Server I did not have a green arrow inside the White circle of the Server Manager app running in the sys tray. If I opened Server Manager the named instance did not appear in the drop-down box. If I manually typed in the \\servername\instancename,
After several attempts to comminucate with the named instance of SQL Server on the Server, I installed a default instance of SQL Server.
Now when the server is rebooted Server Manager does display the default instance running, but still does not show the named instance in the drop-down box (I have to type it in manually).
I still can not register either the named or default instance on my workstation using Enterprise Manager. I also tried to create an ODBC connection to both the default and named instance to no avail.
However ODBC connections on the Server will commincuate with both instances (named and default).
I have seen several posts on the web refering to Server Utilities and Client Utilities but with very little information on how to use these tools. If these tools are needed to resolve the issue please include information (or link to information) on how to use them.
thanks,
matchbx.
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.






EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
2 enabled protocols TCP/IP and Named Pipes
on the Alias Tab 2 server alias are listed (The default instance and the named instance).
SQL Server Service Manager on my workstation show both the named and the default instance in the drop-down box and both are currently running.
adwiseman you were close.... I had to enable protocols on the Server not my development machine. As it turned out the Network Admin's who set the Server up did not make sure it was logging into the domain. Instead I was logging in to the local machine. I am assuming that since I installed MSDE being logged in this way no protocols were enable by default. Once I enabled the protocols and logged into the domain everything worked....
P.S To enable protocols on a MSDE installation navigate to "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\svrne

Get a FREE t-shirt when you ask your first question.
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
Microsoft SQL Server
--
Questions
--
Followers
Top Experts
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.