| Author |
Topic |
|
snez
Starting Member
16 Posts |
 Posted - 2008-10-16 : 17:29:52
|
| I'm successful at loading SQL SERVER 2005 DEV edition on my system (VISTA x64) but I cannot get the server ("named instance") I create during installation to show up in the "Local Servers" tab in SQL Server Management Studio. It shows up in the "Network Servers" tab instead. |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-10-16 : 17:35:40
|
| ON the drop down list of server type, what do you have selected ? |
 |
|
|
snez
Starting Member
16 Posts |
Posted - 2008-10-16 : 18:06:03
|
| Database Engine |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-16 : 18:25:34
|
| use Hostname\namedinstance to connect to named instances in Database engine. |
|
|
|
snez
Starting Member
16 Posts |
Posted - 2008-10-16 : 18:43:39
|
| Get the following error after entering Hostname\namedinstance: Login failed for user 'XXX\XXX'. (Microsoft SQL Server, Error: 18456)Error message detail states: If you are trying to connect using Windows Authentication, verify that you are properly logged into the correct domain.Do I still need access to the network even if I'm trying to create the server locally on my machine? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-16 : 18:57:58
|
| what do you see in SQL Server Config manager for named instances? |
|
|
|
snez
Starting Member
16 Posts |
Posted - 2008-10-16 : 19:00:48
|
| FYI: I now have access to the network but I still get the same error (Login failed for user 'XXX\XXX'. (Microsoft SQL Server, Error: 18456)). |
|
|
|
snez
Starting Member
16 Posts |
Posted - 2008-10-16 : 19:03:21
|
| SQL Server Browser - running, SQL Server Agent(named instance) - running, SQL Server(named instance) - running, SQL Server FullText Search(named instance) - stopped |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-16 : 19:08:28
|
| If you have installed in local servers, then why are you worried about network. Did you reboot your computer after installing Dev edition and Service packs? |
|
|
|
snez
Starting Member
16 Posts |
Posted - 2008-10-16 : 19:11:32
|
| The named instance keeps showing up in my "network servers" tab. No, have not rebooted or installed service packs. Will try that tomorrow. Thx for all your help. |
|
|
|
snez
Starting Member
16 Posts |
Posted - 2008-10-17 : 10:40:39
|
| I installed SP2. At the end of the update I was given the option to grant my user administrative priviledges. After granting my user priviledges I was able to connect to the named instance. The problem is the named instance is still only showing up in my "network servers" tab and not my "local servers" tab. |
|
|
|
snez
Starting Member
16 Posts |
Posted - 2008-10-17 : 11:02:11
|
| The question now becomes: How do you create a server locally after the initial installation of SQL Server 2005 Developer Edition and application of service packs? |
|
|
|
|
sql server 2005 dev ed local server