Problem with SQl connection

Question

Problem with SQl connection

elmnas

SSC-Addicted

Points: 412
More actions
October 14, 2015 at 1:50 am

#308801

Hello People,
I have set up a new virtual machine in Hyper V manager (installed windows 7 professional).
Also installed SQL server Express 2008 R2, the machine is not connected to our domain its just in (WORKGROUP)
The SQL server works fine I have also set up rules for inbound connections through Windows firewall:
I followed this tutorial
then I actually turned of the firewall cause I couldn't ping the virtual machine from another PC (time out)
Below is a picture where linqpad is installed on the same virtual machine also connected to the database:
below is same machine but connected to SQL server management:
that works fine:
Here is another computer that is connected to our domain:
I get this error:
I have tried following stuff..
I have put In the host machine where SQL server is installed in the hostfile:
127.0.0.1 localhost
127.0.0.1 ttdev
127.0.0.1 ttdevlocalhost
still doesnt work.
I also tried to connect to the virutal machine sql database by using the local IP cause I can ping it:
when I run nslookup I get:
Server:unknown:
Adress:192.168.0.12
***UnKnown can't find ttdev: Non-existent domain.
Could someone help me?
Thank you in advance

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Ant-Green SSC Guru Points: 113507 More actions · Answer 1

The servername in the last picture doesn't look right, there shouldn't be a \ at the beginning.

Just TTDEV\TEKNOTRANS_DEV, asuming that the hostfile on the remote box has been updated to have TTDEV listed with its IP address as its off the domain.

You will also need to ensure that remote connections have been enabled as well on the Express server

elmnas SSC-Addicted Points: 412 More actions · Answer 2

anthony.green (10/14/2015)
The servername in the last picture doesn't look right, there shouldn't be a \ at the beginning.
Just TTDEV\TEKNOTRANS_DEV, asuming that the hostfile on the remote box has been updated to have TTDEV listed with its IP address as its off the domain.
You will also need to ensure that remote connections have been enabled as well on the Express server

It doesnt work.

Could you help me out by teamviewer?

Thank you in advance

elmnas SSC-Addicted Points: 412 More actions · Answer 3

elmnas (10/14/2015)
anthony.green (10/14/2015)
The servername in the last picture doesn't look right, there shouldn't be a \ at the beginning.
Just TTDEV\TEKNOTRANS_DEV, asuming that the hostfile on the remote box has been updated to have TTDEV listed with its IP address as its off the domain.
You will also need to ensure that remote connections have been enabled as well on the Express server
It doesnt work.
Could you help me out by teamviewer?
Thank you in advance

actually something happened when run ping on ttdev I actually get the name back not a long unspecificed character pattern.

also I get this error in linqpad

Ant-Green SSC Guru Points: 113507 More actions · Answer 4

Whats putting the \ at the beginning of the servername?

The servername should be TTDEV\TEKNOTRANS_DEV or 192.168.0.12\TEKNOTRAVS_DEV (assuming that IP is the IP for the machine called TTDEV) not \TTDEV\TEKNOTRANS_DEV

Have you confirmed remote connections are setup correctly on the SQL instance?

elmnas SSC-Addicted Points: 412 More actions · Answer 5

I have tested that I recieve exactly same error message.

Ant-Green SSC Guru Points: 113507 More actions · Answer 6

Sorry I missed something glaringly obvious.

Your using Windows Authentication, the server isn't on the domain so you cant use windows auth, you need to use SQL auth.

But the error message you getting is a network issue. So either the second box cant talk (ping, telnet TTDEV), TTDEV isnt setup for remote connections, the connection string is incorrect, tcp/ip / named pipes protocol disabled

elmnas SSC-Addicted Points: 412 More actions · Answer 7

anthony.green (10/14/2015)
Sorry I missed something glaringly obvious.
Your using Windows Authentication, the server isn't on the domain so you cant use windows auth, you need to use SQL auth

I have no clue what the username and password is?

Where do I find that in SQL mangement?

Ant-Green SSC Guru Points: 113507 More actions · Answer 8

elmnas (10/14/2015)
anthony.green (10/14/2015)
Sorry I missed something glaringly obvious.
Your using Windows Authentication, the server isn't on the domain so you cant use windows auth, you need to use SQL auth
I have no clue what the username and password is?
Where do I find that in SQL mangement?

You need to create the user manually under security and add it to the DB

Ant-Green SSC Guru Points: 113507 More actions · Answer 9

http://blogs.msdn.com/b/sqlexpress/archive/2005/05/05/415084.aspx

https://msdn.microsoft.com/en-us/library/aa337562(v=sql.100).aspx