April 27, 2009 at 3:12 pm
Hi all,
I have been struggling for the past several months to figure out why only server database are showing in my SQL Server 2005 instance and not my localhost. Does anyone know why? If you do please advise.
Thank you much.
April 27, 2009 at 3:44 pm
I am not sure what you mean - where are you looking for localhost and it is not appearing?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 28, 2009 at 6:50 am
Hi Jeff,
Thanks for replying. When I go into SQL Server Management Studio, the connect to server screen appears for user to select various server, in the second drop down combo box which is the Server name box, only the network server names appear. When I type Localhost in Server name box, I should be able to access local server which should be the c drive. I am not getting that. I am starting to wonder could this be a network issue?
Thanks for your help.
Julia
April 28, 2009 at 7:49 am
Are you sure you have installed server on you machine?
If yes then trying connecting giving .(dot) as server name.
If ur using sqlexpress try ./sqlexpress
April 28, 2009 at 8:36 am
That drop-down works more as an MRU type of list - basically listing the most recently used server connections. There is another tab available on that dialog - select that tab and you can view all of the servers available locally and remotely.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 28, 2009 at 2:25 pm
Hi,
I am starting to think it's the networkbio on my pc that is preventing the local server installation. I try everything mentioned here and still don't see anything. Thank you for your help though.
April 29, 2009 at 1:52 am
Hi Jewel,
Please check if 'MSSQL.1' folder is exists into '..\Program Files\Microsoft SQL Server\'? - Do you have enough rights on the system?
- R u logged in with the same username/pwd which you define at installation time?
- All necessary services for SQL are running?
If all seems well and though you are getting the same problme, i suggest to install a new instance of SQL Server with new instance name instead of 'SQLExpress' (which might be exists).
"Don't limit your challenges, challenge your limits"
April 29, 2009 at 3:53 am
Hi jewel,
Have you tried browsing it manually?
or tried typing the instance manually?
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply