[thelist] how to connect to MSDE SQL Server?

Chris Johnston chris at fuzzylizard.com
Thu Apr 15 11:36:06 CDT 2004


Ken Schaefer wrote:

>Of course you can connect to MSDE across the network. :-)
>
>a) That said, you need to specify what network library you are trying to
>use. For example, SQL Server/MSDE allows TCP/IP by default, however if you
>have some kind of firewall on the server that is blocking the ports SQL
>Server/MSDE uses (1434/1433), then you're not going to be able connect
>across the network using TCP/IP. Similar for the other protocols (named
>pipes etc)
>
>b) SQL Server has two authentication modes. Integrated Windows, and Mixed
>Mode (Integrated Windows + SQL Server). Microsoft is pushing Integrated
>Windows Authentication, rather than Mixed Mode (which will soon become a
>legacy feature). With IW Auth, you need to:
>    - grant the appropriate windows account permissions to login to the
>database
>    - give the login appropriate rights to the databases in question
>    - connect to SQL Server using that Windows context
>
>
>  
>
Okay, I have installed Enterprise Manager on the computer and can 
connect to the server. I am also able to create an ODBC connection to a 
database on that computer. However, what I can not do is connect to the 
server using Enterprise Manager from another computer on the same network.

When I try and register the server, which is sees with no problems, it 
keeps trying to login using the Guest account. My login account on both 
computers is the same and I have no trouble using to access shares 
across the two computers. Any idea what I am doing wrong?

Also, does anyone have any experience using Aqua Data Studio to remotely 
connect to a MS SQL Server?

chris

-- 
www.fuzzylizard.com



More information about the thelist mailing list