开发者

How can i find my data source name for my SQL Server 2008?

开发者 https://www.devze.com 2023-04-05 16:01 出处:网络
I have a data connection Data Source=.\\\\SQLEXPRESS;AttachDbFilename=\'C:\\\\a\\\\b\\\\bd.mdf\';Integrated Security=True;

I have a data connection

Data Source=.\\SQLEXPRESS;AttachDbFilename='C:\\a\\b\\bd.mdf';Integrated Security=True;
Connect Timeout=30;User Instance=True

With what am I supposed to replace .\\SQLEXPRESS and where can I find the desired information?

I u开发者_运维百科sed to have SQL Server Express 2008 but now I have installed SQL Server 2008 full version


It will be your computer name, but you have to replace more than just that.

Data Source=myServerAddress; Initial Catalog=myDataBase; Integrated Security=SSPI;


Replace . With your server name. You need server name and your instance name. Your instance is usually default instance name or whatever you named it. Use localhost if it's the same server.

Catalog name as well is the name of the database. You can see these names in SQL mgmt studio.

0

精彩评论

暂无评论...
验证码 换一张
取 消