|
AttachDB with SQL Server 2005 Express, does it need to -
January 2nd, 2008
be installed on server? Hi, I'm trying to replace my MS Access DB with a SQL Server 2005 Express DB. My goal is to just attach to the Db like I do with Access because I don't have admin rights to my host server (1and1.com)
I was able to get the "AttachDbFilename: |DataDirectory|,mdf"(I had to change the actual string because yahoo was blocking file paths i think) to work locally where I have sql server express installed.
But when I upload to my host it gives me an error:
"SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified"
Any suggestions as to how I can get a sql server 2005 express db working without having to monkey with the host settings?
|