2014年7月13日 星期日

[RESOLVED] connect to sql server


Sql Server 2008 R2 is stalled in staging server..



can i use staging server sql reference in my local pc ??


(Locally when i will run any website .. web.config will point that use staging sql server reference)


thanks



Yes you should be able to connect to it directly within the same domain.



Hi,


Yes, if it in the same domain or turst domain. 


For connect the database, the connectstring should be like the following:


Data Source={server name/ip};Initial Catalog={database name};User ID={username};password={password}; MultipleActiveResultSets=True;

Hope it can help you.


Best Regards,

Amy Peng 


沒有留言:

張貼留言