sql server express hosting
AttachDB with SQL Server 2005 Express, does it need to 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?
I don’t think you can attach to a remote mdf file without SQL server express being installed on the server. It is after all a client server database and you haven’t got a server installation to connect to. You need to ensure your host provides SQL server for you to upload your database to.
How To Make A MapleStory Private Server ( GMS v0.55 ) ( TitanMS )
