Login to SQL Server management studio

Hi,

I am facing a strange behavior during loging in to SQL server mangement studio.

Whenever I install SQL server express, various protocols like Named Pipe and TCP/IP and SQL browser are disabled by default. But still I am able to log in to SQL Server throguh Management studio.

But when I try to log in to SQL server throguh one of my applications, it allows me to log in to it only for one time. From next time onwards, I am not able to log in to SQL server neither through my application nor through Management studio.

I connect to SQL server using "machine name"\"Instance name". Machine name is the name of machine on my office LAN.

PS: Once this problem occurs, I can log in to SQL server if I use "localhost" instead of "machine name".

Any suggestions would be tremendously helpful.

Regards

-Orion

SQL Express supports connecting through Shared Memory, which is a local connectivity protocol that is used by the SQL Native Client. This is how you're connecting with Management Studio. I can't tell you what the problem is with your application as you have not provided an error message or error log.

Mike

|||

Hi Mike,

Thanks for the reply.

>>
I can't tell you what the problem is with your application as you have not provided an error message or error log
>>

Following are the details of the exception thrown by SQL server.

{"State:08001,Native:6,Origin:[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] State:01000,Native:11004,Origin:[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]"}

The problem is when it allows my application to connect to SQL Server only once. After this, I need to enable TCP/IP protocol for any subsequent connection through my application or SQL Server management studio.

Regards,
Orion

|||

Hi Orion,

Could you define what you mean by "subsequent connections through my application"? Are you talking about a single application creating multiple threads connecting to SQL Server? Are these different copies of the same application being run by other users on other computers? What is the connection string you're using from your application?

I don't recognize that error, is there any more descirptive text?

Mike

Login problem after DB restore

SQL 7.0 using SQL/Windows authenication.
A DB backup was restored from one server to another which
had a new install of SQL 7.0.
Problem:
In EM/Security, if I try to add the user login 'xxx' with
access to the restored DB, SQL says the login name
already exists in the the DB. Yet, it doesn't exist, that
I can see any where. If I try to access the DB from an
ODBC connection using the login 'xxx' it denies access.
I tried droplogin 'xxx', but that didn't help.
Any ideas?
Thanks,
DonRead up on sp_change_users_login within Books Online. I am sure that it =
will solve your problem.
--=20
Keith
"Don" <anonymous@.discussions.microsoft.com> wrote in message =
news:763a01c406aa$374e45a0$a601280a@.phx.gbl...
> SQL 7.0 using SQL/Windows authenication.
>=20
> A DB backup was restored from one server to another which=20
> had a new install of SQL 7.0.=20
>=20
> Problem:
> In EM/Security, if I try to add the user login 'xxx' with=20
> access to the restored DB, SQL says the login name=20
> already exists in the the DB. Yet, it doesn't exist, that=20
> I can see any where. If I try to access the DB from an=20
> ODBC connection using the login 'xxx' it denies access.
> I tried droplogin 'xxx', but that didn't help.
> Any ideas?
> Thanks,
> Don
>

Login problem

My database server : local
My database name : MyDatabase
Mode : Windows Authentication Mode (I choose it when I first install sql server 2000)

Using the abovementioned information, I create login using the following statements:

sp_addlogin @.loginame = 'iori'
, @.passwd = '225468'
, @.defdb = 'MyDatabase'
, @.deflanguage = 'english'

After I have compiled the statements, new login is successfully created. But I am having problem to log in into sql server when I try to connect to sql server through Query Analyzer.

I click on 'connect', then a pop up box appears, then I select (local) as my sql server, and in 'connect using', I select 'SQL Server authentication', and finally, I type in my user name as 'iori' and passward as '225468'. I get an error message:

Unable to connect to server IORI...

Login failed for user 'iori'. Not associated with a trusted SQL Server connection.

Can anyone help me in this?Make Sure MS Desktop Engine's service is running, u r giving your server name as (local), which seems to be ok, u can also give dot sign (.) instead , under windows authentication mode it should work

Check for MSDEngine service or install desktop engine if u dont have one. Post again if problem persists...gud luk

Regards
BSS|||Thanks, I have solved the problem.