SQL Server 2005 Express edition Registration.
-
Hi, I'm trying to register SQL Server Express edition engine into Network. I've checked everything, but I'm not able to find it in the servers list. What are the things I should check more? I check TCP/IP & Named pipes connections, Enabled Remote connections, *Restarted the service* **Restarted the machine**! But nothing works. May be that's what you call Express edition?
-
Hi, I'm trying to register SQL Server Express edition engine into Network. I've checked everything, but I'm not able to find it in the servers list. What are the things I should check more? I check TCP/IP & Named pipes connections, Enabled Remote connections, *Restarted the service* **Restarted the machine**! But nothing works. May be that's what you call Express edition?
-
Hi, I'm trying to register SQL Server Express edition engine into Network. I've checked everything, but I'm not able to find it in the servers list. What are the things I should check more? I check TCP/IP & Named pipes connections, Enabled Remote connections, *Restarted the service* **Restarted the machine**! But nothing works. May be that's what you call Express edition?
ConquistadorEx wrote:
I'm trying to register SQL Server Express edition engine into Network.
You'd have to explain that a bit. Once installed, all should be fine. Where are you registering it? What application?
ConquistadorEx wrote:
What are the things I should check more?
Whether the SQL Browser service is running. Check MSDN[^]. Also, check your firewalls, and try to connect to the database using SQL Management Studio or ISql.exe.
I are Troll :suss:
-
Was it a default instance? Should be
ServerName\SQLEXPRESSfrom memory.I don't speak Idiot - please talk slowly and clearly 'This space for rent' Driven to the arms of Heineken by the wife
Yes this is what is shown when I browse for SQL servers in the n/w through Management studio. It gets displayed in the servers list in the local Mgmt studio. But when I open the studio from another machine, I'm not able to see. And it's vice-versa for the DB server that's hosted in the other machine. I'm not able to see it from my mgmt studio. But it gets displayed on his own mgmgt studio. You get it?
-
ConquistadorEx wrote:
I'm trying to register SQL Server Express edition engine into Network.
You'd have to explain that a bit. Once installed, all should be fine. Where are you registering it? What application?
ConquistadorEx wrote:
What are the things I should check more?
Whether the SQL Browser service is running. Check MSDN[^]. Also, check your firewalls, and try to connect to the database using SQL Management Studio or ISql.exe.
I are Troll :suss:
Please check my reply above. I'm just right clicking on the server instance displayed in the Mgmt Studio then selecting "Register".
-
Please check my reply above. I'm just right clicking on the server instance displayed in the Mgmt Studio then selecting "Register".