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 |
|
derekvsi
Starting Member
1 Post |
 Posted - 2010-03-19 : 09:48:52
|
| I created a database on a SQL 2005 server, and put my login name as the DB owner. When i try and link our backup program(Arcserve) to the database with my login information, it tells me unable to login to MS SQL. What else could i be missing? |
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2010-03-23 : 06:59:02
|
quote:
Originally posted by derekvsi
I created a database on a SQL 2005 server, and put my login name as the DB owner. When i try and link our backup program(Arcserve) to the database with my login information, it tells me unable to login to MS SQL. What else could i be missing?
verify that the authentication is set to mixed mode authentication. |
 |
|
|
thewebhosting
Starting Member
17 Posts |
Posted - 2010-03-24 : 18:00:24
|
| Hi,Check with these options:- Reset the details ion server and reflect it in the connection string.- Make sure that you have used correct port to connect to your SQL web server. If you do not have any details of it then you can contact your service provider and get the details. Generally, MS SQL is running on 1533 port.- Make sure that MS SQL web server is not down. |
|
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2010-03-24 : 18:15:48
|
| 1433?=======================================There are no passengers on spaceship earth. We are all crew. -Marshall McLuhan, educator and philosopher (1911-1980) |
|
|
|
|
|
|
Unable to connect to SQL database