Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
sfjtraps
Yak Posting Veteran
65 Posts |
Posted - 2014-01-28 : 14:25:48
|
I'm trying to establish a connection id from a virtual machine running xp to a SQL Server Express database on Windows 7. The connection id functioned correctly when I was connecting my application to the SQL Server Express while both were on the same computer. However, both still are on the same computer, but the application is on a virtual machine now and I'm having trouble understanding how to connect to the data source in the connection id.I can ping from the virtual machine to the host computer, so I know there is a connection.Here's the data source I was using that did work when the application and the database were on the same computer.DataSource=mycomputer\SQLEXPRESSAny help fixing this issue would be greatly appreciated. |
|
sfjtraps
Yak Posting Veteran
65 Posts |
Posted - 2014-01-28 : 14:33:36
|
It keeps stating SQL Server does not exist or access is denied. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-01-28 : 14:36:16
|
Has SQL Express been configured to allow remote connections?Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
sfjtraps
Yak Posting Veteran
65 Posts |
Posted - 2014-01-28 : 14:42:49
|
I checked, and under Server Properties, 'Allow remote connections to this server' is checked. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-01-28 : 15:10:46
|
This is likely a SQL Browser issue. Is the SQL Browser service started on the database server? If it is, then is there a firewall between the two computers? If not, then you can almost certainly resolve this with a SQL alias.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
sfjtraps
Yak Posting Veteran
65 Posts |
Posted - 2014-01-28 : 16:24:58
|
I turned on the SQL Browser service, but it is still not working. I'm using a UDL file to try to establish a connection, but it does not seem to be working. I also tried to establish an ODBC System DSN, but it will not find the SQL Server. I'll look into the sql alias. |
|
|
|
|
|