timothyjb
Member
I can successfully make a connection to a database on a remote server using SQL Server Management Studio, but when I try to connect to the same database using the add connection wizard in Server Explorer in VB.NET 2008 (Standard version), I get the following error message:
The File "\\Server\sql data\databasename.mdf" is on a network path that is not supported for database files. An attempt to attach an auto-named database for file \\Server\sql data\databasename.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
I can however connect to a system database on the remote server - "master", for instance. I just can't connect to a database in a directory on the server, even though I can connect using Management Studio.
I'm using SQL Server 2008 Workgroup. My operating system is Vista Home Premium. I intend to try the connection on a workstation using Vista Business as soon as I can get access to it.
Tim
The File "\\Server\sql data\databasename.mdf" is on a network path that is not supported for database files. An attempt to attach an auto-named database for file \\Server\sql data\databasename.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
I can however connect to a system database on the remote server - "master", for instance. I just can't connect to a database in a directory on the server, even though I can connect using Management Studio.
I'm using SQL Server 2008 Workgroup. My operating system is Vista Home Premium. I intend to try the connection on a workstation using Vista Business as soon as I can get access to it.
Tim