Showing posts with label saying. Show all posts
Showing posts with label saying. Show all posts

Monday, March 26, 2012

How to connect to a server (sql server 2005

Hi Everyone

I'm trying to connect to a server using SQL Server Management studio but I have an error message saying "an error has occurred while establishing a connection to the server" error 1231

I have no knowledge about SQL server 2005 and SQL Server Management studio.

I presume I need to create a server first (but how?)

Could you tell what I need to do do connect to a server?

Many thanks in advance
EmilYou can either setup your own SMS Gateway using a GSM modem connected to a PC, or you can connect to an SMS Gateway provider like http://www.clickatell.com through the Internet, or you can use a combination of both. There are open source gateways like http://www.kannel.org and also commercial gateways like http://www.visualtron.com.

Regards,
Joshua
SMS Server@.Expert

how to connect to a local sql server on your laptop?

i have problems connecting to the local server on my laptop. i ahve used the following code but it gives me an error saying login flaied for user "sa" or "sekhar".

i tried using the username and password i use to log onto my computer. but it doesnt work.
can anyone tell me how to do it?

the code is typed is

connection = new sqlconnection("server=localhost;uid=sekhar;pwd=sekhar;database=chandu")
..................
.............................
........................
connection.open()..............i have all the next statements correct.
my username is sekhar and the password is sekhar too but it gives me an error.
somebody help me

Thank you

sekhartry using server=(local)

and whether you need the password or not depends on how the SQL Server is set up. does the users view show a user called 'sekhar'? no? when you right click the server node and go to properties->security, does it show windows auth only, or Windows and SQL Server auth?