|
lost password
Lost sa password for SQL Server. The data is not important, but would prefer
not to re-install.
Thanks ...
Wed, 12 Jan 2005 08:03:04 -0800
|
CA not valid
Hello,
I need first to test SSL-Encryption on an standalone SQL Server 2000 Server.
For this, I became a Personal CA from a friend and the appropriated Trusted
Root CA. I requested it with the User who start the SQL Server services (an
administrator user)
All looks fine under MMC, but SQL Server does not fin ...
Wed, 12 Jan 2005 05:55:03 -0800
|
Error 53, Cannot generate SSPI Context
SQLserveragent service for SQL2K does not start and returns the
following error in the agent out file.
Error 53, Cannot generate SSPI Context
We have researched this error on Microsoft and several news groups and
none of the stuff we read seems to work.
We CAN connect to the DB using the full DNS name or ...
Tue, 11 Jan 2005 18:25:23 -0600
|
Session Role??
I worked a lot in Oracle in the past, and recently switched to SQL Server. I
had a little feature in my program works in Oracle, I don't know what find
the SQL server part of the feature, could anyone help.
In Oracle , Every user account with the database has a default role
assigned, and it can do limited ...
Tue, 11 Jan 2005 10:47:04 -0800
|
Reset permissions
Hello,
I am looking for a script that will work dynamically depending on which
database I am in. I want to run the GRANT or DENY based upon a certain group
and I would prefer not to select each table the EM. Is there a script out
there that can read the tables and generate a permission script off of it ...
Tue, 11 Jan 2005 06:33:27 -0800
|
Doubling up security on SQL Server system administrator
Hi All
Always baffled me this, but although I can set up complex SQL usernames and
passwords for my SQL database the main system administrator login details
only give me half the security because the username is always 'sa'. I can
only set a complex password for the most powerful user of them all.
This mi ...
Tue, 11 Jan 2005 14:02:04 -0000
|
Permissions question
Hi,
I need to give access to a domain user group DOMAIN\Developers so that they
can ONLY start/stop SQL Jobs. Which is the best role to grant.
Thanks
Reddi ...
Mon, 10 Jan 2005 23:49:03 -0800
|
Replication Not working for a table
We have about 20 tables setup for replications . All std.
setup . Replication is using stored procs created by SQL
Server instead of the Statements. All tables are fine
except one table stpped changing data at all. No errors
etc.
What should I do.
Table has 2 coulms as PK . using SQL stored proc,
...
Mon, 10 Jan 2005 10:15:31 -0800
|
DBCC Traceon
Hello all,
I have written a procedure which imports data into SQL Server from MySQL
using driver 3.51.06. Nothing unusual til now but the fact that the stored
procedure is using dbcc traceon (8765). So, I grant execute to an ordinary
user on the procedure, the user can execute it but the procedure throws the
e ...
Sun, 9 Jan 2005 20:09:39 +0200
|
Find Database Users
I'm wondering if there is a way I can query against a
system table to find out all the users on a server and
what permissions they all have? If anyone has any ideas I
would really appreciate it! Thanks!
...
Fri, 7 Jan 2005 16:32:38 -0800
|
How to access SQL Server on another domain with Windows authentica
I have two computers, client and server. The client is running Windows 2000
Professional and is in a workgroup, say "MyWorkgroup". The server is running
Windows Server 2003 Standard Edition and is in a domain, say "MyDomain".
The server has SQL Server 2000 Standard Edition with SP3a installed and is
usin ...
Fri, 7 Jan 2005 14:49:01 -0800
|
Post-sp3a Patches?
Are there any patches are updates for SQL Server 2000 that are NOT included
in service pack 3a? I have a customer thinking that additional sql server
patches are required on a server but I don't believe that there are any that
are not already included in 3a which this server has.
Thanks.
Michelle
...
Fri, 7 Jan 2005 11:05:12 -0600
|
SQL 7.0 ACCESS from Trusted AD Group Fails
We are migrating from NT to Active Directory. For some
time we will have users in both NT and AD needing access
to a SQL 7 database. I have created a group in AD, and
added my users to it. I have created a logon in SQL
Security setup and given it rights to the database and
tables my users need.
When ...
Fri, 7 Jan 2005 07:58:51 -0800
|
Find permission on different object for a role
In our database, we have a set of roles.
Some roles are members of other roles.
Example
Role_Basic has access to select from tables Client and Customer
Role_Salesperson has access to select from Sales
Role_Salesperson is a member of Role_Basic, so users that belongs to the
Role_Salesperson has select per ...
Fri, 7 Jan 2005 02:31:02 -0800
|
What technology do I need to run a home based business
What computers, servers, and software do I need to resale audio recording
products over the web how do I get a new web site going? ...
Fri, 7 Jan 2005 01:39:02 -0800
|