Hi,
I'm trying to set up a CMS locally, using a MSSQL database. Ordinarily I do this on a live web server via a test domain, but I'd like to start developing locally rather than having to FTP things all the time. I have IIS running locally, which is fine, but am struggling big-time to get a SQL database running locally (more specifically, to connect to a local database).
I just cannot connect to any local MSSQL database instance using anything other than Windows Authentication. I logged into SQL Server Management Studio as Administrator; created a database; created a new log-in (under Security > Log-ins, using SQL Server Authentication, with a password, and with 'Enforce password policy' unchecked); created a new user under the new database > security folder, using mapping to the new user and with 'db_datareader', 'db_datawriter' and 'db_owner' checked in the 'database role membership' area.
However, my CMS says it can't connect to the database. I try logging into SQL Server Management Studio using the user created above, and get the following error:
TITLE: Connect to Server
Cannot connect to OFFICE\SQLEXPRESS.
ADDITIONAL INFORMATION:
A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476
BUTTONS:
OK
The 'help' at microsoft says that it's because the SQL Server is not configured to accept remote connections (how is it remote, when it's all local?). So I've logged into Management Studio as administrator, right clicked the database instance and gone to properties. In there I've ensured that under connections, the 'Allow remote connections to this server' checkbox is checked. Also, under Security it's set to allow Windows and SQL Server authentication.
So I'm totally stuck. How on earth can I get this to work!?
Thanks for any pointers.