| Author |
Topic |
|
snez
Starting Member
16 Posts |
 Posted - 2008-10-17 : 11:32:13
|
| How do you create a server locally after the initial installation of SQL Server 2005 Developer Edition and application of service packs? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-10-17 : 11:40:58
|
| Run Management studio and login. |
 |
|
|
snez
Starting Member
16 Posts |
Posted - 2008-10-17 : 12:09:31
|
| By engine do you mean named instance? I can see the instance in my "Network Servers" tab but not in my "Local Servers" tab in Management Studio which leads me to believe it is on my network but not locally on my machine. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
snez
Starting Member
16 Posts |
Posted - 2008-10-17 : 12:33:42
|
| How do you register the instance in Mgmt Studio? When I open Mgmt Studio I get the Connect to Servers screen. I select Database Engine for Server Type and Select <Browse for more > in Server Name which then brings up the Browse for Servers screen. It is at this point that I'm thinking I should see my instance in the "Local Servers" tab rather than in the "Network Servers" tab. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
snez
Starting Member
16 Posts |
Posted - 2008-10-17 : 13:36:16
|
| I can connect either way. Using HostName\InstanceName or (local)\InstanceName. I think what was throwing me was that I did not see my instance on the "Local Servers" tab. Still not sure why that is.Other developers cannot see my instance on their machines (on their "Network Servers" tab) which I think proves it is only local on mine. Thank you so much for all your help. |
|
|
|
SimpleSQL
Yak Posting Veteran
85 Posts |
Posted - 2008-10-17 : 23:06:31
|
| First verify if you have SQL installed on your local machine as follows.Check Services, by going to Control Panel --> Administrative tool --> Services.Check if you have SQL Server Serivce runnign on your local machine (if it is default instance for SQL Server 2005, service would show up as "SQL Server (MASQLSERVER)", for named instance, you would have a service as "SQL Server (NAMEOFINSTANCE)"If the services are present, this means you have SQL installed locally on your machine.You should be able to connect to them via SQL Server Management Studio as. <-- for local using Windows Auth (assuming your account has correct privilege to connect to SQL), or using .\instancename for named instance. |
|
|
|
|
Create a local server on SQL Server 2005 Dev ed