Sunday, February 19, 2012

Can't connect to Sql Server 2005

After install Sql Server 2005 as administrator, I enter in the computer as a
limited user. When I start the Management Studio I can't see any data base.
I checked that the service is started and I tried creating a new start
sesion with the name of the limited user in the domain (as I did in sql
server 2000) but it doesn't work.
What else can I do?
Thank you very much."alberto" <alberto@.nospam.es> wrote in message
news:O4JyJ5hSHHA.1036@.TK2MSFTNGP03.phx.gbl...
> After install Sql Server 2005 as administrator, I enter in the computer as
> a limited user. When I start the Management Studio I can't see any data
> base. I checked that the service is started and I tried creating a new
> start sesion with the name of the limited user in the domain (as I did in
> sql server 2000) but it doesn't work.
> What else can I do?
Log into SQL Server as an administrator and create a login for your limited
user, assigning that user either server roles, or database access as
appropriate.
David|||I just did it but I still can't connect. As limited user I don't see any
server.
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> escribió en el
mensaje news:OubC9BiSHHA.3980@.TK2MSFTNGP02.phx.gbl...
>
> "alberto" <alberto@.nospam.es> wrote in message
> news:O4JyJ5hSHHA.1036@.TK2MSFTNGP03.phx.gbl...
>> After install Sql Server 2005 as administrator, I enter in the computer
>> as a limited user. When I start the Management Studio I can't see any
>> data base. I checked that the service is started and I tried creating a
>> new start sesion with the name of the limited user in the domain (as I
>> did in sql server 2000) but it doesn't work.
>> What else can I do?
>
> Log into SQL Server as an administrator and create a login for your
> limited user, assigning that user either server roles, or database access
> as appropriate.
> David|||"alberto" <alberto@.nospam.es> wrote in message
news:#KRbFOiSHHA.5068@.TK2MSFTNGP03.phx.gbl...
>I just did it but I still can't connect. As limited user I don't see any
>server.
>
Can't see it? or can't connect? What are you entering in the "server name"
box in the SQL Server Management Studio connect dialog? What error message
are you getting?
David|||In the combo box of servers I don't see anything.
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> escribió en el
mensaje news:%23r3b$biSHHA.5068@.TK2MSFTNGP03.phx.gbl...
>
> "alberto" <alberto@.nospam.es> wrote in message
> news:#KRbFOiSHHA.5068@.TK2MSFTNGP03.phx.gbl...
>>I just did it but I still can't connect. As limited user I don't see any
>>server.
> Can't see it? or can't connect? What are you entering in the "server
> name" box in the SQL Server Management Studio connect dialog? What error
> message are you getting?
> David|||"alberto" <alberto@.nospam.es> wrote in message
news:##3e2fiSHHA.192@.TK2MSFTNGP04.phx.gbl...
> In the combo box of servers I don't see anything.
>
Then type in the name of the server, or if you are on the same box, type
'(local)'. If you installed a named instance add the instance name.
Default Instance:
MyServer
(local)
Named instance (called MyInstance)
MyServer\MyInstance
(local)\MyInstance
David

No comments:

Post a Comment