Can't conenct to sql 2005

Hi,
Can you connect to SQL 2005 if you're not part of the domain the server is
installed in?
I installed the client and it can see my SQL 2000 server but not the SQL
2005 server.
Is it because the laptop I installed it on is not part of the domain?
If so, beside having it join the domain, is there a way to connect to it?
Thanks!
Simon
Hi,
this is not easy tell. Is SQL Server 2005 installed on the same box as SQL
Server 2000 ? Does it have a default port or any other than the 1433 port ?
If using a dynamic or any other port, do you have SQL Browser started on the
2k5 box ? If you cant start SQL Browser for some reason, did you try to
specify the port number after the server name to make the connection using
Servername,Portnumber as the servername within your connection dialogues ?
Jens K. Suessmeyer.
http://www.sqlserver2005.de
"Simon Renshaw" <simon@.benchmarkconsulting.com> wrote in message
news:OHQCXfoYHHA.4008@.TK2MSFTNGP05.phx.gbl...
> Hi,
> Can you connect to SQL 2005 if you're not part of the domain the server is
> installed in?
> I installed the client and it can see my SQL 2000 server but not the SQL
> 2005 server.
> Is it because the laptop I installed it on is not part of the domain?
> If so, beside having it join the domain, is there a way to connect to it?
> Thanks!
> Simon
>
|||No, 2005 and 2000 are installed on different machines. And I used the
standard ports.
By the client I meant the SQL Server Management Studio. Sorry for the
confusion.
On my station (which is part of the domain), I can access the 2005 server
using SQL Server Management Studio.
On the laptop, I cannot access the 2005 server using SQL Server Management
Studio.
"Jens K. Suessmeyer" <Jens@.NoSpamhere-sqlserver2005.de> wrote in message
news:82730AB1-9842-4B47-A61E-BAED0215B0DE@.microsoft.com...
> Hi,
> this is not easy tell. Is SQL Server 2005 installed on the same box as SQL
> Server 2000 ? Does it have a default port or any other than the 1433 port
> ? If using a dynamic or any other port, do you have SQL Browser started on
> the 2k5 box ? If you cant start SQL Browser for some reason, did you try
> to specify the port number after the server name to make the connection
> using Servername,Portnumber as the servername within your connection
> dialogues ?
> Jens K. Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "Simon Renshaw" <simon@.benchmarkconsulting.com> wrote in message
> news:OHQCXfoYHHA.4008@.TK2MSFTNGP05.phx.gbl...
>

Cant add "ComputerName\ASPNET user

I see a lot of people have this same problem, but I still can't find a solution. I keep getting a "SqlException: Login failed for user 'domain\user name'Error when I try and access my SQL db from my web app. I've tried adding the ASPNET user to my db, but am unable to. Here are the steps I took:

SQL 2000 ent manager
-Windows NT
-Logins (right Click)
-New login
-Name <click>
but once I'm here, I can't find the ASPNET user name, and I am unable to create it here, or under the database users. Any help? It works fine on my local machine.

Do I need to install the .NET framework on my SQL server?

You don't need--exactly speaking you can not create a Windows account in SQL, what you can do is just adding existing Windows account to SQL logins. So just input myserver\ASPNETas login name while choosing Windows Authenticaiton. If you can't add myserver\ASPNET and get an error saying "Windows user or group can not be found...", then check the login failure error message from .NET. What's the login name in the error message? Is it myserver\ASPNET?If you're using IIS 6.0, the login name should be 'NT AUTHROITY\NETWORK SERVICE'

Can't acess RS2005 in a domain environment?!

hi,
I have installed SQL 2005 on server A and RS 2005 on server B.
server C is the domain controller.
Every thing works fine when i browse the virtual directories on the local
machine (B).
When i try to acess RS virtual directories from my XPSP2/IE7 workstation i
am prompted for windows credentials, but i keep getting "You are not
authorize to view this page" even though my domain account is a memeber of
Administrators on RS2005 server B. it happens with other XP clients as well.
Why is that? What is wrong here?
the RS2005 has its default installation base on the windows authentication
method for the virtual directories.
rs2005 settings are:
website: defaul
SSL: NO
Windows service identity: Local system
Web service identity: application pool "ap1" with my domain account (member
of local admin group)
db setup: SQL server login = 'sa'
thanks in advance
rafiOn Jan 9, 4:39 am, Rafi <R...@.discussions.microsoft.com> wrote:
> hi,
> I have installed SQL 2005 on server A and RS 2005 on server B.
> server C is the domain controller.
> Every thing works fine when i browse the virtual directories on the local
> machine (B).
> When i try to acess RS virtual directories from my XPSP2/IE7 workstation i
> am prompted for windows credentials, but i keep getting "You are not
> authorize to view this page" even though my domain account is a memeber of
> Administrators on RS2005 server B. it happens with other XP clients as well.
> Why is that? What is wrong here?
> the RS2005 has its default installation base on the windows authentication
> method for the virtual directories.
> rs2005 settings are:
> website: defaul
> SSL: NO
> Windows service identity: Local system
> Web service identity: application pool "ap1" with my domain account (member
> of local admin group)
> db setup: SQL server login = 'sa'
> thanks in advance
> rafi
Are you allowing anonymous access to the Reports and ReportServer
virtual directories? This could be the problem. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||no. anonymous access is not enabled.
only "Integrated windows auth.." is marked.
i always prompted for my domain credentials when using a browser from XP
xlient while i am loged in with my domain account
still need help!
Rafi
"EMartinez" wrote:
> On Jan 9, 4:39 am, Rafi <R...@.discussions.microsoft.com> wrote:
> > hi,
> >
> > I have installed SQL 2005 on server A and RS 2005 on server B.
> > server C is the domain controller.
> > Every thing works fine when i browse the virtual directories on the local
> > machine (B).
> >
> > When i try to acess RS virtual directories from my XPSP2/IE7 workstation i
> > am prompted for windows credentials, but i keep getting "You are not
> > authorize to view this page" even though my domain account is a memeber of
> > Administrators on RS2005 server B. it happens with other XP clients as well.
> >
> > Why is that? What is wrong here?
> >
> > the RS2005 has its default installation base on the windows authentication
> > method for the virtual directories.
> >
> > rs2005 settings are:
> > website: defaul
> > SSL: NO
> > Windows service identity: Local system
> > Web service identity: application pool "ap1" with my domain account (member
> > of local admin group)
> > db setup: SQL server login = 'sa'
> >
> > thanks in advance
> >
> > rafi
>
> Are you allowing anonymous access to the Reports and ReportServer
> virtual directories? This could be the problem. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||Check the following:
ReportServer and Reports virtual directory should set for windows
authentication.
Start a command prompt, then navigate to the C:\Inetpub\Adminscripts
folder
where the adsutil.vbs located.
Check the authentication providers with this in the command prompt:
cscript
adsutil.vbs get w3svc/NTAuthenticationProviders
If you get "The parameter "NTAuthenticationProviders" is not set at
this
node" message, then type cscript adsutil.vbs set
w3svc/NTAuthenticationProviders "NTLM" in cmd. After this try to open
the
report manager from a remote machine.
I hope this solves the problem.
Regards,
Bob
On Jan 13, 1:53=A0am, Rafi <R...@.discussions.microsoft.com> wrote:
> no. anonymous access is not enabled.
> only "Integratedwindowsauth.." is marked.
> i always prompted for my domain credentials when using a browser from XP
> xlient while i am =A0loged in with my domain account
> still need help!
> Rafi
>
> "EMartinez" wrote:
> > On Jan 9, 4:39 am, Rafi <R...@.discussions.microsoft.com> wrote:
> > > hi,
> > > I have installed SQL 2005 on server A and RS 2005 on server B.
> > > server C is the domain controller.
> > > Every thing works fine when i browse the virtual directories on the lo=cal
> > > machine (B).
> > > When i try to acess RS virtual directories from my XPSP2/IE7 workstati=on i
> > > am prompted forwindowscredentials, but i keep getting "You are not
> > > authorize to view this page" even though my domain account is a memebe=r of
> > > Administrators onRS2005server B. it happens with other XP clients as w=ell.
> > > Why is that? What is wrong here?
> > > theRS2005has its default installation base on thewindowsauthentication=
> > > method for the virtual directories.
> > >rs2005settings are:
> > > website: defaul
> > > SSL: NO
> > >Windowsserviceidentity: Local system
> > > Webserviceidentity: =A0application pool "ap1" with my domain account (=member
> > > of local admin group)
> > > db setup: SQL server login =3D 'sa'
> > > thanks in =A0advance
> > > rafi
> > Are you allowing anonymous access to the Reports and ReportServer
> > virtual directories? This could be the problem. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant- Hide quoted text -
> - Show quoted text -

can't access server - lost sa password

We have what we think is msde running on a box. No one knows the sa password.
I am in the domain admin group on Windows and the Windows admin group but
when I right click on BUILTIN\administrator, I don't get the "properties"
menu selection. I also can't create a new login.
A few weeks ago I was able to create a new login and a new database. I'm not
sure what happened. My windows login is not there anymore but I would have
thought I could use the BUILTIN\administrator login to admin the server.
Any ideas on how I can get control of the server?
Thanks,
Dan D.
Although I hate tools like these but try this tool if it works for you ...
http://www.nextgenss.com/sqlcrack.htm
Harman Sahni
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:E449D233-29E8-4ED0-AC95-2B4BF0FDC6D3@.microsoft.com...
> We have what we think is msde running on a box. No one knows the sa
password.
> I am in the domain admin group on Windows and the Windows admin group but
> when I right click on BUILTIN\administrator, I don't get the "properties"
> menu selection. I also can't create a new login.
> A few weeks ago I was able to create a new login and a new database. I'm
not
> sure what happened. My windows login is not there anymore but I would have
> thought I could use the BUILTIN\administrator login to admin the server.
> Any ideas on how I can get control of the server?
> Thanks,
> --
> Dan D.
|||Thanks but I figured out the sa password. I'll keep this for future reference.
"Harman Sahni" wrote:

> Although I hate tools like these but try this tool if it works for you ...
> http://www.nextgenss.com/sqlcrack.htm
> Harman Sahni
>
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:E449D233-29E8-4ED0-AC95-2B4BF0FDC6D3@.microsoft.com...
> password.
> not
>
>
|||Dan
Log in SQL Server with Windows Authentication and run EXEC sp_password NULL,
'NewPass', 'MyUser
'
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:2264F204-A7B6-422A-95AC-0517B560C27C@.microsoft.com...
> Thanks but I figured out the sa password. I'll keep this for future
reference.[vbcol=seagreen]
> "Harman Sahni" wrote:
...[vbcol=seagreen]
but[vbcol=seagreen]
"properties"[vbcol=seagreen]
I'm[vbcol=seagreen]
have[vbcol=seagreen]
server.[vbcol=seagreen]

Cannot view DB properties

Upgraded from SQL 2000 to SQL 2005. I am using Domain User with admin rights
to view the DB properties and its failing with "Property Owner is not
available for Database '[DB_name]'. This property may not exist for this
object, or may not be retrievable due to insufficient access rights.
(Microsoft.SqlServer.Smo)"
I was able to view the properties of the same database using same domain
user when we were in SQL 2000.
How to solve this issue? Any input is appreciated..
ThanksIT (IT@.discussions.microsoft.com) writes:
> Upgraded from SQL 2000 to SQL 2005. I am using Domain User with admin
> rights to view the DB properties and its failing with "Property Owner is
> not available for Database '[DB_name]'. This property may not exist fo
r
> this object, or may not be retrievable due to insufficient access
> rights. (Microsoft.SqlServer.Smo)"
> I was able to view the properties of the same database using same domain
> user when we were in SQL 2000.
> How to solve this issue? Any input is appreciated..
How did you upgrade? Did you upgrade the server in place, to did you
reattach the database?
It sounds as the latter. The SID for the database user, does not seem to
match any login on the server. Use
ALTER AUTHORIZATION ON DATABASE:db TO [domain\user]
and if necessary, create a login for the domain user first.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||I did In-Place Upgrade, I have like 20 databases and when I checked using
sp_helpdb for all databases, found NULL for 5 databases.
I followed the command
ALTER AUTHORIZATION ON DATABASE::database_name TO sa
Failed with:
Msg 15110, Level 16, State 1, Line 1
The proposed new database owner is already a user or aliased in the database
.
Any other workarounds? Is this a Bug...in SQL 2005...
"Erland Sommarskog" wrote:

> IT (IT@.discussions.microsoft.com) writes:
> How did you upgrade? Did you upgrade the server in place, to did you
> reattach the database?
> It sounds as the latter. The SID for the database user, does not seem to
> match any login on the server. Use
> ALTER AUTHORIZATION ON DATABASE:db TO [domain\user]
> and if necessary, create a login for the domain user first.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx
>|||IT
Sorry, I don't understand , what do you mean by "In-Place Upgrade"?
I just did testing and it worked fine.
1) BACKUP DATABASE command on SQL Server 2000
2) RESTORE DATABASE command on SQL Server 2005
3) Drop user in the database after restoring
4) CREATE LOGIN on SQL Server 2005
5) CREATE USER in the database and mapped it to the new created LOGIN
If it does not help, please privide with steps you did so far.
"IT" <IT@.discussions.microsoft.com> wrote in message
news:A8BF2B36-4223-49A6-948B-E5097FC52082@.microsoft.com...[vbcol=seagreen]
>I did In-Place Upgrade, I have like 20 databases and when I checked using
> sp_helpdb for all databases, found NULL for 5 databases.
> I followed the command
> ALTER AUTHORIZATION ON DATABASE::database_name TO sa
> Failed with:
> Msg 15110, Level 16, State 1, Line 1
> The proposed new database owner is already a user or aliased in the
> database.
>
> Any other workarounds? Is this a Bug...in SQL 2005...
>
> "Erland Sommarskog" wrote:
>|||Here are the steps I followed:
# Ran the setup and upgraded the existing SQL Server 8.00.818 to SQL Server
2005.
# I have like 20 databases and only for 5 databases I noticed that database
owner was NULL after the UPgraded finished successfully.
# I checked that by using sp_helpdb...IN the OWNER filed found NULL for
those 5 databases.
# Ran sp_changedbowner 'sa' and it updated the OWNER to SA
# If I want to change the owner to any existing user in the database it
gives me
following error.
Msg 15110, Level 16, State 1, Line 1
The proposed new database owner is already a user or aliased in the
database.
I can only change the Owner to sa and for any other USER if throws me the
error I mentioned above.My question here is , Even though I upgraded the
existing instance of 2000 to 2005, why is that only for 5 databases I am
seeing this kind of behaviour.
Every thing was fine when it was in sql 2000.I was able to change the DB
Owner...
Thanks
"Uri Dimant" wrote:

> IT
> Sorry, I don't understand , what do you mean by "In-Place Upgrade"?
> I just did testing and it worked fine.
> 1) BACKUP DATABASE command on SQL Server 2000
> 2) RESTORE DATABASE command on SQL Server 2005
> 3) Drop user in the database after restoring
> 4) CREATE LOGIN on SQL Server 2005
> 5) CREATE USER in the database and mapped it to the new created LOGIN
>
> If it does not help, please privide with steps you did so far.
>
>
> "IT" <IT@.discussions.microsoft.com> wrote in message
> news:A8BF2B36-4223-49A6-948B-E5097FC52082@.microsoft.com...
>
>|||Sounds like a phantom user situation which is causing your error to be
thrown.
Check out http://sta.c64.org/sqlprg.html
And download http://sta.c64.org/sqlprg/fixusers.zip
Before you run the script be sure and read what it does.
Good luck to ya.
IT wrote:[vbcol=seagreen]
> Here are the steps I followed:
> # Ran the setup and upgraded the existing SQL Server 8.00.818 to SQL Serve
r
> 2005.
> # I have like 20 databases and only for 5 databases I noticed that databas
e
> owner was NULL after the UPgraded finished successfully.
> # I checked that by using sp_helpdb...IN the OWNER filed found NULL for
> those 5 databases.
> # Ran sp_changedbowner 'sa' and it updated the OWNER to SA
> # If I want to change the owner to any existing user in the database it
> gives me
> following error.
> Msg 15110, Level 16, State 1, Line 1
> The proposed new database owner is already a user or aliased in the
> database.
> I can only change the Owner to sa and for any other USER if throws me the
> error I mentioned above.My question here is , Even though I upgraded the
> existing instance of 2000 to 2005, why is that only for 5 databases I am
> seeing this kind of behaviour.
> Every thing was fine when it was in sql 2000.I was able to change the DB
> Owner...
>
> Thanks
> "Uri Dimant" wrote:
>|||The users in the databases have respective logins on the server. There are n
o
orphaned users on the database. The issue is we cannot change the DB owner t
o
the existing users in the database except for SA.
"jebuskrust@.gmail.com" wrote:

> Sounds like a phantom user situation which is causing your error to be
> thrown.
> Check out http://sta.c64.org/sqlprg.html
> And download http://sta.c64.org/sqlprg/fixusers.zip
> Before you run the script be sure and read what it does.
> Good luck to ya.
>
> IT wrote:
>|||IT (IT@.discussions.microsoft.com) writes:
> The users in the databases have respective logins on the server. There
> are no orphaned users on the database. The issue is we cannot change the
> DB owner to the existing users in the database except for SA.
That is not possible on SQL 2000 either.
The login that owns the database always maps to the dbo user. If the login
already maps to a user in the database, the login can't become the database
owner, because he would then map to two users.
Thus you need to explicitly drop the users that you want to own the
databases.
I can't answer why you only got a problem with 5 of 20 databases. The
answer for that may be hidden in their previous history.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Cannot stop or start SQL server from SQLEM

Hi,
Merry Christmas to Everyone.
We have a SQL2k server that is not in any domain (in a
workgroup). I registered it in the Enterprise Manager on
my workstation with the sa account. However, I can do
anything but stop or start the SQL server and server
agent. Here is the error message:
An error 5 - (Access is denied) occurred while performing
this service operation on the SQLServerAgent service.
Any suggestions?
Thanks.
David WangServices are an OS thing, not an SQL thing. Log in as
admin.
>--Original Message--
>Hi,
>Merry Christmas to Everyone.
>We have a SQL2k server that is not in any domain (in a
>workgroup). I registered it in the Enterprise Manager on
>my workstation with the sa account. However, I can do
>anything but stop or start the SQL server and server
>agent. Here is the error message:
>An error 5 - (Access is denied) occurred while performing
>this service operation on the SQLServerAgent service.
>Any suggestions?
>Thanks.
>David Wang
>.
>|||Yes, you are right. I have no problem to do this if I log
in from the local server. I am trying to do this from a
remote machine. I thought the sa account could impersonate
the local system admin role.
Thanks.
>--Original Message--
>Services are an OS thing, not an SQL thing. Log in as
>admin.
>>--Original Message--
>>Hi,
>>Merry Christmas to Everyone.
>>We have a SQL2k server that is not in any domain (in a
>>workgroup). I registered it in the Enterprise Manager on
>>my workstation with the sa account. However, I can do
>>anything but stop or start the SQL server and server
>>agent. Here is the error message:
>>An error 5 - (Access is denied) occurred while
performing
>>this service operation on the SQLServerAgent service.
>>Any suggestions?
>>Thanks.
>>David Wang
>>.
>.
>|||sa is not an administrator to the operating system.

cannot setup SQL server 2000 service account during installation

Hi, i tried to install MS SQL server 2000 in my XP system but during the setup service account installation, i tried to use a domain user account but it cannot validate my user name and password. I used my windows administrator logon account and password. Please help..thank you.

Thanks : :confused:If you successfully installed SQL Server 2000, now you may change the user of the service accounts in the services (My Computer->Services and Applications->Services).

Paulo|||Thank you for your reply but this happened during the installation and i do not wish to install SQL server using the local system account for the service account as i need it to work over the network, SQL mail, backup and etc.

Thanks|||Thank you for your reply but this happened during the installation and i do not wish to install SQL server using the local system account for the service account as i need it to work over the network, SQL mail, backup and etc.

Thanks

The use of the Local System Account for the service account makes sure that no matter what, the SQL Server will be running. Even if the Domain/AD/Network is down the SQL server will be running.

Using the Local System Account for the system account does/should not affect whether or not the server is visable over the network. Enable TCP/IP, named pipes, etc. as a server communication protocol and it will be visable and then determine how you want people to authenticate to the server(Windows or SQL Server authentication)

Have Fun...