SQL/TV Server setup help. (1 Viewer)

[Freak]

I'm having some problems with SQL and the Test Server.

In the Video #3 the Setup database screen is slightly different to mine.

Basically i get an error message:

I Have:
-------------------------------------------------------------
Microsoft SQL Server 2005

MySQL 5

Hostname - PC-Name\SQLEXPRESS

Service - MSSQL$SQLEXPRESS

Login - sa

Password - sa
--------------------------------------------------------------

If i click TEST i recieve this:

"Connection Failed! An error has occurred while establishing a connection to the server, When connecting SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, Error 26 Locating Server/Instance Specified)"

And the Service Name - MSSQL$SQLEXPRESS (section highlights red)

So i guess it has to do with this setting MSSQL$SQLEXPRESS.

Does anyone know what i'm meant to put, the Video #3 does not have this dialog.

Any help would be appreciated.

 

[joboehl]

That depends on how you setup you MSSQL database. In some cases you need the $SQLEXPRESS and in other you don't.

But it looks like a different issue. Check if SQL Server is running (in services panel) for example.

One idea is to download the SQLServer Management Studio Express and try to connect with it.

 

[rtv]

Either you're not using the Express Edition or you've changed the name of the default "instance".

But as joboehl already pointed out this isn't related to your connection problems at all.

There are many posts && answers regarding that "cannot connect to sql server" misconfigurations.
If you're not comfortable with M$'s SQL server you can safely install and use MySQL which will work almost out of the box.

 

[Freak]

Thanks guys for the quick reply...

I did manage to get it done:

I had to change the service name simply to MSSQSERVER
And also my host name to something differernt to the default

i.e PC-Name\SQLEXPRESS didn't work,
Just putting the PC name by itself was accepted....

So thanks for all the suggestions, problem is now fixed.