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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 new sql server express server

Author  Topic 

c_owl
Starting Member

5 Posts

Posted - 2010-05-12 : 08:51:09
hi all.
i have just installed ms sql server 2008 express, im new to sql moving from ms access.

after installing sql i can view the batabase on the machine i installed sql. but when i try to connect to the sql server from another machine, it will not let me login .

i have looked at the firewall ports and 1433 tcp port is open.
i have looked at the database server properties. and that is set to sql server and windows auth.
i have checked the TCP/IP and all is open to 1433 on ip addresses

i still cant get logged in to the sql server using sql server management studio on another machine.

can anyone help im stuck

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-05-12 : 09:01:32
Have you tried:
<name_of_computer_where_express_is_running>\SQLEXPRESS as server?

See also here:
http://www.connectionstrings.com/sql-server-2008


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

c_owl
Starting Member

5 Posts

Posted - 2010-05-12 : 12:23:50
tryed it still cant connect to it
Go to Top of Page

c_owl
Starting Member

5 Posts

Posted - 2010-05-14 : 19:54:04
hi webfred.
i managed to do it.. i uninstalled express and re-installed it. re-done all the config firewall and so on and it works. after adding user info to the sql users..
Go to Top of Page
   

- Advertisement -