Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
leoparsd
Starting Member
6 Posts |
 Posted - 2007-04-22 : 18:17:59
|
| hi guys, i asked for a sql server database from a hosting company. they provided me with a username and a password but i couldnt connect to the database getting the error "sql server does not exist or access denied", then i started to think do i gain all access to entire sql server by the password and username provided in the connection string in the web.config file, if not how do i create a connection string which adresses to a specific database with specific user credentials in sql server. i am pretty off to the sql server administration topics, i use sql server mostly with queries and etc while using with asp.net for software development.thanks in advance |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-22 : 20:33:50
|
| Can you ping the sql server from your machine? Is sql port open between your network and hosting company? |
 |
|
|
leoparsd
Starting Member
6 Posts |
Posted - 2007-04-23 : 02:42:23
|
| yes i can ping the server successfully but how can i tell if the sql server port is open? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-23 : 10:34:29
|
| Have to check with your network guys and hosting company. |
|
|
|
leoparsd
Starting Member
6 Posts |
Posted - 2007-04-23 : 10:50:57
|
| yes i resolved the problem. problem was about our network configuration. our adsl modem didnt allow outgoing request for sql server ports 1433(as i remember). We changed the access control policy and finally it worked.thank you. |
|
|
|
|
|
|
connection string- username- password