connection to Mssql database | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

connection to Mssql database

hi,
i am using mssql server2k as backend for website. i want to transfer my tables(db) which r on local server to web server. currently i am using dialup connection & connecting to db on webserver & using using import/export method i m transfering my tables from local db to webserver db. In our office we r having broadband connection , we r using proxy connection. can any one tell me how to register webserver’s db through proxy. i using method new server registration & in that i m giving IP address of webserver & also userid ,passwd of sql server db ,but it is not connecting. if i use same technique through direct connection(via dial up)then it is registering the server. also one more query
when i am using import/export for tranfering the tables,it is distroying properties of tables like it removes primary key or it makes fields which r having numeric data type,it is converting to decimal. can any one tell me solution of this.
Hi,
i refer you to read below links : http://support.microsoft.com/kb/q216415/ http://groups.google.co.in/group/mi…5092765e49fab9e?sa=X&oi=groupsr&start=0&num=3 http://www.samspublishing.com/articles/article.asp?p=30168&rl=1
Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami

]]>