March 22, 2009 at 2:54 am
Hi all,
I have just installed sql server 2005 on Windows XP SP 3. When I do try logging in, I am not getting any server names. I tried checking in SQL Server Config manager but, I can t see any options like server protocols shared memory, tcp/ip....
Any idea wht is wrong here?
March 22, 2009 at 3:31 am
did you create a default or named instance?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 22, 2009 at 4:13 am
Dont know how to do that? Can you advise me? 🙂
March 22, 2009 at 4:42 am
ok, try from another angle! Did you accept all the defaults during installation or did you change any sections of the installer (such as the part where it indicates create a default or supply a named instance)?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 22, 2009 at 4:52 am
I dont think I encountered with any options during installation.
Should I try installing again ?
May be this database setup has not got enough files to support the server.
I got this software from online sharing website.
March 22, 2009 at 5:58 am
Hi
First:
Go to "Start" -> "Programs" -> "SQL Server 2005" -> "Configuration Tools" -> "SQL Server Configuration Manager". Select node "SQL Server Services". In detail view you see the installed components of SQL Server like "SQL Server" behind the service type you see the name of the instance. "MSSQLSERVER" is the name of the default (not named) instance. What do you see there? Is the services state "Running"?
Second:
Open command line and execute "sqlcmd -L". This may take about one minute. The sqlcmd tool scans the network for any running SQL Servers. Do you see the name of your server (with or without a backslash)?
Greets
Flo
March 22, 2009 at 6:11 am
I can't see anything while clicking at sql server services in sql server config manager.
I tried running the sqlcmd -L but output is blank like this...
Servers:
March 22, 2009 at 6:18 am
So it seems that you have installed no SQL Server.
You wrote you are running Windows XP. You can only install the SQL Server Developer or Express Edition on a client OS. If you are trying to install Standard or Enterprise edition this is not possible on your OS.
I guess your installation routine told you in any step that only the client tools will be installed. Download the Express Edition or buy a Developer Edition (if only needed for testing or development). If you need for production work and the Express Edition does not fit your requirements you need a Windows Server 2003/2008 license.
Greets
Flo
March 22, 2009 at 6:47 am
the OS reqs are at the following link
http://msdn.microsoft.com/en-us/library/ms143506(SQL.90).aspx
you can install either Standard, workgroup, express or developer only on XP Pro SP2
and developer or express on XP Home
is your OS XP Pro or XP Home?
Have a check through services.msc for any sql related services and let us know what is present but it sounds like you didnt check the option to install a database server during setup
check the link above and you will find install instructions for SQL2005!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 22, 2009 at 7:08 am
Perry Whittle (3/22/2009)
the OS reqs are at the following linkhttp://msdn.microsoft.com/en-us/library/ms143506(SQL.90).aspx
you can install either Standard, workgroup, express or developer only on XP Pro SP2
and developer or express on XP Home
Hi Perry
Thanks also for information! Since now I have been sure that it never was possible to install a production version (except express) of SQL Server on a client OS.
Greets
Flo
March 22, 2009 at 7:42 am
naimish_2005 (3/22/2009)
I got this software from online sharing website.
??????
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 22, 2009 at 7:46 am
GilaMonster (3/22/2009)
naimish_2005 (3/22/2009)
I got this software from online sharing website.??????
!!!!
Sorry, I read over this...! Thanks Gail!!!
naimish:
Could you please explain!
March 22, 2009 at 7:47 am
GilaMonster (3/22/2009)
naimish_2005 (3/22/2009)
I got this software from online sharing website.??????
yeah i know slightly supsect and worrying.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 22, 2009 at 7:51 am
To Gail, Perry (and some other people)
Thanks for your corrections in this thread and others. I'm not from England/America and sometimes I'm tryin' to read faster than my English allows... 😀
Greets
Flo
March 22, 2009 at 8:10 am
Florian Reischl (3/22/2009)
To Gail, Perry (and some other people)Thanks for your corrections in this thread and others. I'm not from England/America and sometimes I'm tryin' to read faster than my English allows... 😀
Greets
Flo
the poster doesnt actually state what version sql they are installing, if its express then there's no issue its free from M$ anyway. However if its dev or std,etc then obvious copyrights are infringed
give them a chance to come back and give further info, my guess is they won't 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 15 posts - 1 through 15 (of 17 total)
You must be logged in to reply to this topic. Login to reply