sql server connection?????or login with query analyzer????????????
-
hi friends i have a server that installed o it a sql server 2000 i want to create a connection to the database on this sql server. my server name is (local); when i try to login into my database from query analyzer: i type "(local)" instead of server name and username and password of a auser that i created for login to database. its worked correctly. but when i try to do this action from my home pc, an error appear that contanis below message: "Sqlserver does not exist or access denied." i enter my server ip instead of "(local)" in my query analyzer from my home pc. now how can i login to my database from my home pc???? what do i enter server name ? an ip address or else??? please help me
nobody help you... you have to help you yourself and this is success way.
-
hi friends i have a server that installed o it a sql server 2000 i want to create a connection to the database on this sql server. my server name is (local); when i try to login into my database from query analyzer: i type "(local)" instead of server name and username and password of a auser that i created for login to database. its worked correctly. but when i try to do this action from my home pc, an error appear that contanis below message: "Sqlserver does not exist or access denied." i enter my server ip instead of "(local)" in my query analyzer from my home pc. now how can i login to my database from my home pc???? what do i enter server name ? an ip address or else??? please help me
nobody help you... you have to help you yourself and this is success way.
(local) only works if you are logged in locally to the machine where the instance of SQL Server is installed. You will probably need to use the IP address of the machine from home, unless you have some way to resolve the hostname (like if you are logged in thru a VPN). Then you can type in your username and password into QueryAnalyzer just like you would if you were on the machine locally.
Mark's blog: developMENTALmadness.blogspot.com