October 9, 2009 at 6:48 pm
Hello Forum.
I have installed SQL Server 2008 on a network and it seems to be installed with no problem. I was sure to specify it as a Network Service account.
But other programs that should be able to access the database are unable to connect.
What steps should I go through to ensure that the database is up and running correctly?
October 11, 2009 at 9:24 am
randythesofaking (10/9/2009)
Hello Forum.I have installed SQL Server 2008 on a network and it seems to be installed with no problem. I was sure to specify it as a Network Service account.
But other programs that should be able to access the database are unable to connect.
What steps should I go through to ensure that the database is up and running correctly?
The Express edition and the developer edition installs with most features disabled so go into configuration manager and enable both named pipes and TCP/IP. You also need to make sure you change the account running SQL Server service from network service because it is a limited account that will limit what sql server can do. Post again if you still need help.
Kind regards,
Gift Peddie
October 12, 2009 at 4:10 pm
Well, before I do that, I need to fix something that I see as being a problem. It appears I was installing the wrong version of SQL Server. I was installing the express version. I think there is also an issue with installing an x86 version on a x64 machine.
So first things first. I need to completely uninstall what I have installed. Here is what I have done. I have stopped the sql services on my machine. Then I went through the uninstaller and uninstalled all the programs starting with SQL. Then I went into the programs directory and I renamed the MICROSOFT SQL SERVER directory.
But when I restart the program, I still see one of the sql services still listed in the list.
How do I get rid of that?
Even after running the Windows Cleanup Utility (http://support.microsoft.com/kb/290301), the services are still running.
October 14, 2009 at 2:04 pm
Follow these steps to enable remote connections for MSSQL: http://support.microsoft.com/default.aspx/kb/914277
------------
StarWind Software developer ( http://www.starwindsoftware.com )
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply