Remove all permission restrictions

I have a site where my client attempted to change a lot of
authenticated users and I helped (aided and abetted?) him by scripting
over the previouls permissions. We are having a lot of problems now and
want to get back to a completely public editable and open database
before replanning roles and users and restricting rights.
To further complicate the issue, this database is a publisher and
although we have generated a snapshot, we haven't deployed it until
this is fixed - we don't want two sites where users can't see or edit
the data!
I would like to know the simplest way to make the database owned by
dbo, strip all non system users and roles, and to be able to make NT
Authority/Authenticated Users members of the dbowner role.
Thanks
Steve SoltSteve
> I would like to know the simplest way to make the database owned by
> dbo, strip all non system users and roles, and to be able to make NT
> Authority/Authenticated Users members of the dbowner role.
>
Take a look at sp_changedbowner system stored procedure
<s.solt@.czwgarchitects.co.uk> wrote in message
news:1160671910.190428.264470@.h48g2000cwc.googlegroups.com...
>I have a site where my client attempted to change a lot of
> authenticated users and I helped (aided and abetted?) him by scripting
> over the previouls permissions. We are having a lot of problems now and
> want to get back to a completely public editable and open database
> before replanning roles and users and restricting rights.
> To further complicate the issue, this database is a publisher and
> although we have generated a snapshot, we haven't deployed it until
> this is fixed - we don't want two sites where users can't see or edit
> the data!
> I would like to know the simplest way to make the database owned by
> dbo, strip all non system users and roles, and to be able to make NT
> Authority/Authenticated Users members of the dbowner role.
> Thanks
> Steve Solt
>

Remote database connection through internet still not working

I am trying to have a ADO OLEDB connection by the UDL tool. However, it
still reports that there is no SQL server or no permission to access the
server. How can I test whether there was no contact at all or was it a
permission issue ?
I also use a forward URL which is routed by the DNS to the server IP adress.
Could that be the problem ? I enforced not to use the internet IP adress
because the router establishes a LAN connecion (both server and client
resides on same LAN) and doesn't connect through the internet as I figured
out.
Which steps should i perform in the right sequence in order to find the
problem ?
regards,
OscarHi,
I have the same problem but I just want to connect the SQL Server database
in my Windows2003 Server std webserver on my local entreprise manager...
No firewall between the two machines...
Thanks
LJ
www.eztree-msdn.com
"Oscar" <oku@.xs4all.nl> a crit dans le message de
news:4057ab71$0$28004$e4fe514c@.dreader17
.news.xs4all.nl...
> I am trying to have a ADO OLEDB connection by the UDL tool. However, it
> still reports that there is no SQL server or no permission to access the
> server. How can I test whether there was no contact at all or was it a
> permission issue ?
> I also use a forward URL which is routed by the DNS to the server IP
adress.
> Could that be the problem ? I enforced not to use the internet IP adress
> because the router establishes a LAN connecion (both server and client
> resides on same LAN) and doesn't connect through the internet as I figured
> out.
> Which steps should i perform in the right sequence in order to find the
> problem ?
> regards,
> Oscar
>

Remote connection problem

I have SQL Server 2005. My system is in a local network. In the network others are able to access my database. I have the permission to access the database of others but still I am not able to access the others database.

Can any body tell me that what can be the reason?

Best Regards,

Kanhaiya Lal

Which error do you get during connecting?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Please provide more detail info here, such as what error message you came across? Did you see any clue in Server ERRORLOG? Is it connection failure or data operation failure? or others? What is you configuration? such as client connection string, server sku? Remote/local? client and server OS?

Thanks!

Ming

|||What authentication mode was the server installed with ?|||

The error was timeout expired and I have solve it.

Thanks

Kanhaiya