Showing posts with label limited. Show all posts
Showing posts with label limited. Show all posts

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