SQLServer2000 - System Admin Problem

Jun 9, 2004

Hi,

I have SQLServer20000 Enterprise Manager-Version 8.00 and Microsoft Enterprise Manager - V 2.0 Version 5.1 Service Pack 1 and SQL 8.00.760. A "user" owns the database and when I have the user logged to SQL Query Analyzer ( with user and pwd)
When enable Fixed server role as system administrator for that user (owns db)
select * from table1 says that the table does not exist
select * from "owner".table1 gives the records.
When enable fixed server role as security administrator for that user ( owns db)
select * from table1 outputs records
select * from owner.table1 outputs records.
If I have both system administrator and security administrator checked for the user the scenario is like "system administrator" where select statement outputs records only if owner is included in the statement.

When system administrator is the highest role why does it behave this way?

Any help is appreciated.

Thanks
Vinnie

View 3 Replies


ADVERTISEMENT

UNABLE TO CONNECT TO SQLSERVER2000 FROM VS2005 .How To Enable Remote Connection On Sqlserver2000

Sep 10, 2007



Hi,

iam having vs2005 installed on my machine and i also installed sqlserver2005 dev edition on my machine...Now iam devloping a Window Appplication in which I need to populate a grid from Sqlserver2000 (dev edition) which installed on remote (i.e another network)....when i try to run my application it gives me a error tht "Unable to connect to sqlserver2005".actaully i specified in my connection string to connect to Sqlserver2000 on the remote machine.


I feel to know how to enable remote connection on Sqlserver 2000.So tht i can access this sqlserver2000 from another machine

With regards
Mahender

View 1 Replies View Related

SQL Server System Admin Log

Oct 22, 2000

Can any one help me by sending a sample sql server system administration log for day to day administration of sql server.
Thanks
sunthar

View 1 Replies View Related

System Grants Without Admin Rsp.

Oct 31, 2006

What kind of permissions I need, when I want to see the system views, perfstat, ect...but I don't need admin responsibility.

View 1 Replies View Related

Cannot Remove Admin From System Database

Oct 27, 2015

We are using server 2012 and SQL express.I am trying to omplement  a new software called Ifineo and at deployment is dumps the following error (unfortunately French):

2015-10-27 14:36:57.8983|INFO|InsideSQLAssistant.Assistant|Connecteur Sage 100 Gesttion Commerciale v20
2015-10-27 14:37:18.3024|ERROR|InsideSQLAssistant.Assistant|Error (1807): Impossible d'obtenir un verrou exclusif sur la base de données 'model'. Recommencez l'opération ultérieurement.
Échec de CREATE DATABASE. Certains noms de fichiers de la liste n'ont pas pu être créés. Voir les erreurs associées.

[code]...

Now I did try to set it in sing user or multiple user and the following command to kill some parts of it:

select 'KILL ', spid
from master..sysprocesses
where dbid=db_id('Votre Base')

But my admin still remains connected to the DB(I have even disabled it but still the same)there seem to be to persons connected to the db the admin and my account, found that via exec sp_who

View 2 Replies View Related

Why Would System Admin Privileges Be Required To Connect To A Default Instance?

Apr 25, 2007

I have a server with 3 SQL Server named instances on it - servername, servername/TST and servername/GOLDSTD. I have several databases on the default instance (servername) but users cannot access the databases unless they are given system admin privileges to their login. This occurs using both SQL Server Logins and Windows authentication logins. If I move the database to a different named instance (servername/TST), the problem no longer exists and users can connect with dbo privileges. Any suggestions or is this typical for default instances? Thanks in advance for any help

View 8 Replies View Related

SQL Server Admin 2014 :: Changing Compatibility Level Of System Databases

Jun 27, 2014

I have just upgraded a test server from sql server 2008 sp3 to sql server 2014 inplace upgrade. The compatability level of master database has not upgraded. It was showing 90 and the rest of system databases got updated to 120. Is it fine to update the compatibility level of master database ? Any precautions need to taken??

View 1 Replies View Related

SQL Server Admin 2014 :: Installing System Databases To A Non Default Drive?

Mar 25, 2015

How can you install the System Databases to a drive other than the default?

I want the Data Files to be installed on D:MSSQLData and the log files to be stored on D:MSSQLLog.

For better, quicker answers on T-SQL questions, click on the following...

[URL]

For better answers on performance questions, click on the following...

[URL]

View 9 Replies View Related

SQL Server Admin 2014 :: System Objects Could Not Be Updated In Database X Because It Is Read-only

Jul 27, 2015

We installed SP1 for SQL Server 2014 this past weekend and got this error message in the logs. I found that if you set the db to read-write, it updates the system objects, even after SP1 has completed. Then you can set it back to read-only. I'm just posting this so other people can find it on the internet, as I wasn't able to find it specifically.

Error Log Entry:System objects could not be updated in database 'x' because it is read-only.

Problem: After installing SP1 for SQL Server 2014 you will find this message in the error logs saying read-only databases could not be updated.

Solution: Simply set the db to read-write and the system objects will get updated, long after SP1 was installed.

ALTER DATABASE [x] SET READ_WRITE WITH NO_WAIT

Then set it back to read-only:

ALTER DATABASE [x] SET READ_ONLY WITH NO_WAIT

You should then see these log entries:

System objects could not be updated in database 'x' because it is read-only.
Setting database option READ_WRITE to ON for database 'x'.
Starting up database 'x'.
CHECKDB for database 'x' finished without errors on 2015-07-25 01:02:28.143 (local time). This is an informational message only; no user action is required.
Synchronize Database 'x' (129) with Resource Database.
Setting database option READ_ONLY to ON for database 'x'.
Starting up database 'x'.
CHECKDB for database 'x' finished without errors on 2015-07-25 01:02:29.888 (local time). This is an informational message only; no user action is required.

View 0 Replies View Related

User Provisioning Tool For Vista (creating System Admin Accounts

Apr 8, 2008

I am reading kb 934164. I am confused about (creating system administrator) domain user accounts....
IN SQL 2005 USER PROVISIONING Tools
under kb934164 8e type a window account by the following format
domain/user 8k Type a windows account by following format domain/user
DO I simply type domain/user or do I actually Type my domain/user account
What is domain user?
In other words where does domain (PASSWORD) come from?
where does user(PASSWORD) come from?
I have being trying to find the answer for this
Is there anything else I need to be prepared for in user
provisioning. By the way do you need to turn off uac in vista while installing
sql 2005....Thanks Is there any examples of this? I just want to get it right....

View 6 Replies View Related

SQL Server Admin 2014 :: Primary Filegroup For System Objects / Secondary For Data

Jul 27, 2015

I have been creating databases in SQL 2008 with a primary filegroup for the system objects and a secondary, marked Default, for the data.

We are preparing a migration to SQL 2014, and the administrator is complaining he won't adopt this structure on the new servers because 'there is no benefit' and 'a backup cannot be restored (!?)'.

View 2 Replies View Related

SQL Server Admin 2014 :: Changing Drive Letter For System Database And User Databases

Oct 18, 2013

I have system database and user database file are present in G,H and W drive.The process is going to be - copy data from G to S, H to T, W to U. Rename G to X, H to Y and W to Z. Rename S to G, T to H and U to W. Reboot the servers. The original G, H and W will then be X, Y and Z. The old S will be the new G, old T will be H and old U will be W. My question is that after doing this whether my SQL server will start or not

View 8 Replies View Related

SQL Server Admin 2014 :: How To Do System Restore To Previous Restore Point

Dec 31, 2014

In Windows Server 2012. How do I do a System Restore to a previous restore point?I need to install the 64 bit and 32 bit Oracle Client Install for connections in SSIS and to create Oracle Linked Servers.

If you make a mistake it is not fun removing it. Sometimes it corrupts the machine and it is difficult to uninstall since there is not an Oracle Universal installer for Oracle 11g.If you install the 32 bit before the 64 you mess up the machine.how to create a restore point.

View 6 Replies View Related

System.Security.SecurityException: Request For The Permission Of Type 'System.Data.SqlClient.SqlClientPermission, System.Data

Aug 21, 2006

I have created a windows library control that accesses a local sql database

I tried the following strings for connecting

Dim connectionString As String = "Data Source=localhostSQLEXPRESS;Initial Catalog=TimeSheet;Trusted_Connection = true"

Dim connectionString As String = "Data Source=localhostSQLEXPRESS;Initial Catalog=TimeSheet;Integrated Security=SSPI"



I am not running the webpage in a virtual directory but in

C:Inetpubwwwrootusercontrol

and I have a simple index.html that tries to read from an sql db but throws

the error

System.Security.SecurityException: Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet)
at System.Security.PermissionSet.Demand()
at System.Data.Common.DbConnectionOptions.DemandPermission()
at System.Data.SqlClient.SqlConnection.PermissionDemand()
at System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection outerConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection,

etc etc

The action that failed was:
Demand
The type of the first permission that failed was:
System.Data.SqlClient.SqlClientPermission
The Zone of the assembly that failed was:
Trusted


I looked into the .net config utility but it says unrestricted and I tried adding it to the trusted internet zones in ie options security

I think that a windows form connecting to a sql database running in a webpage should be simple

to configure what am I missing?

View 28 Replies View Related

SQL Server Admin 2014 :: Does Security-admin Role Plus Deny Alter Any Login Cancel Each Other Out

Aug 27, 2015

I want to set up a database role so that users can use sp_readerrorlog through SSMS. It does a check on membership in the securityadmin role.

I have tested it and can see you can grant execute on xp_readerrorlog but the SSMS GUI uses sp_readerrorlog.

I thought I could create a user/certificate and add the signature to sp_readerrorlog but it's not permitted (likely because it's not a normal database object).

So the other solution is to add the users to the securityadmin role but then explicitly deny alter any login (best done with a custom server role in 2012+ but otherwise just manually in 2008). I tested this out and it works, I'm not able to alter any logins or increase my own permissions, I also did a check of what's reported from fn_my_permissions(null, null) and it shows minimal permissions like I'd expect.

View 0 Replies View Related

SQLServer2000 Vs ADO VB6

Aug 4, 2004

Hi, I have a little question regarding
SQLServer2000 vs ADO of Visual Basic 6

In a code snipplet a have something like:

Conn1.BeginTrans

Set rec_tmp = Conn1.Execute("SELECT * FROM IDENTIFICATIONS;")

Conn1.Execute "DELETE FROM CARS WHERE CAR_ID = 8;"
.
.
.
Conn1.CommitTrans


and whe VB tries to execute the line with the
DELETE sentence the Err object says something like:
"cannot create a new connection because you are in
distributed or manual transaction mode"

However, if I remove the line that executes the sentence
SELECT * FROM IDENTIFICATIONS the error never shows up.
Seems like I can´t execute a SELECT before a DELETE/UPDATE
even if I execute the SELECT in some other table.
I´ve tried changing the IsolationLevel, Mode and Cursor
Location properties and the error always occurs.
Furthermore, I tried putting the SELECT out of the
transaction and the error continues showing up.

Why does this occurs? Is there a way to solve it?

NOTE: I need forcely to execute that SELECT before the DELETE.

Thanks for the time
Roland

View 2 Replies View Related

SQLServer2000 Vs ADO VB6

Aug 4, 2004

Hi, I have a little question regarding
SQLServer2000 vs ADO of Visual Basic 6

In a code snipplet a have something like:

Conn1.BeginTrans

Set rec_tmp = Conn1.Execute("SELECT * FROM IDENTIFICATIONS;")

Conn1.Execute "DELETE FROM CARS WHERE CAR_ID = 8;"
.
.
.
Conn1.CommitTrans


and whe VB tries to execute the line with the
DELETE sentence the Err object says something like:
"cannot create a new connection because you are in
distributed or manual transaction mode"

However, if I remove the line that executes the sentence
SELECT * FROM IDENTIFICATIONS the error never shows up.
Seems like I can´t execute a SELECT before a DELETE/UPDATE
even if I execute the SELECT in some other table.
I´ve tried changing the IsolationLevel, Mode and Cursor
Location properties and the error always occurs.
Furthermore, I tried putting the SELECT out of the
transaction and the error continues showing up.

Why does this occurs? Is there a way to solve it?

NOTE: I need forcely to execute that SELECT before the DELETE.

Thanks for the time
Roland

View 2 Replies View Related

In Sqlserver2000 Date ?

Oct 11, 2006

date(m/dd/yyyy)9/18/2006 In this above table i want to select only the month in this format Sep 2006 . How to do that ?  

View 1 Replies View Related

Cannot Connect To SQLServer2000

Jul 3, 2007

Hello everyone,My project (asp.net and sqlserver2000) is working fine in my intranet. But sometime, it cannot connect to sqlserver, it shows "SQLServer does not exists or access denied". If I restart my dbserver and webserver, then it again works fine.Please give me a solution.

View 1 Replies View Related

Top Not Getting Supported In Sqlserver2000

Nov 10, 2007

Hi, 
I have  created the below procedure in SQL SERVER 2005.
But when I copy out the same in SQL SERVER 2000. I get an error at the underlined place. It says
Line 32: Incorrect syntax near '('.
 ALTER procedure [dbo].[VTELcardvalidation1]
@CardValue1 int,
@CardValue2 int,
@CardValue3 int,@Result nvarchar(50)output
as
begin
declare @CrdPinNo varchar(100)
declare @CrdNo nvarchar(100)declare @count int
declare @inc int
declare @concat nvarchar(200)create table #temptable(crno nvarchar(50),pno nvarchar(50))
 
--First Card
--Change here
select @count=count(cardno) from vendorcardvalidation where cardvalue=1500 and flag=0if (@count)>@CardValue1
begin
declare cur1 cursor forselect top(@CardValue1) pin,cardno from vendorcardvalidation where cardvalue=1500 and flag=0 order by cardno
open cur1fetch next from cur1 into @CrdPinNo,@CrdNo
while(@@fetch_status=0)
beginupdate vendorcardvalidation set flag=1 where cardno=@CrdNo
insert into #temptable values(1500,@CrdPinNo)fetch next from cur1 into @CrdPinNo,@CrdNo
endclose cur1
deallocate cur1
set @Result='Success'end
else
begin
set @Result='Failure'
end
select * from #temptable
drop table #temptable
end
 
 
It seems the the word 'top' will not be supported in sqlserver 2000. What should I do?
Regards
cmrhema
 
 
 

View 3 Replies View Related

Asp.net Queries With Sqlserver2000

Oct 2, 2005

Sir,i am running .net1.1 on my system with sqlserver as my database.I am devaloping an e-trading project in ASP.NET with VB.net.My problem is that,I am not getting the correct syntax to query the database with SELECT(with WHERE clause)in vb.net.Please help me.

View 1 Replies View Related

Groups In SQLServer2000

Jan 31, 2002

Hi,
I would like to create groups in SQLServer2000.Do i need to do this by roles or can i create groups for each database.I read some where that there where
no groups for SQLServer7.0. Is this option available for the latest versions.
Any help will be appreciated.

Thanks in Advance.
Ran.

View 3 Replies View Related

SQLServer2000- Audit - ALL

Jun 23, 2006

I turned the Audit ALL option on SQLServer instance "security" tab and restarted the SQLServer but do not see any information logged in SQLServer Logs though I tried to access databases and logged in a couple of times through Query Analyzer. Why is that no logging happened and how can I get this fixed?

Any help is appreciated.

Vinnie

View 1 Replies View Related

Handling Errors In Sps In Sqlserver2000

Feb 11, 2008

Hai
I wrote a sp in sqlserver2000 and sp consists of 1 input parameter of type datetime and everything is working fine but if i pass the argument of invalid date format it is giving error.Is there any way to handle errors in sps and even if i give invalid format it should not raise errors.Pls reply as early as possible.
Thanks
Aruna

View 3 Replies View Related

Adding Users SqlServer2000

Oct 7, 2004

More of a SQL Server problem than a ASP one but hope you can help me :)

Im tryin to do my first data based application using ASP.net and silly me I forgot to add users when I created then database so now Visual Studio can't access it.

Can someone tell me the syntax to add/create a user to MSSQL database so I can then grant them privelidges to the tables.

thanks very much

Tom

View 1 Replies View Related

Failure In Connection To SQLserver2000

May 12, 2004

hi all,
my problem is failure in the connection to SQLserver2000 remotly( to city a) by enterprise manager or query analyzer via windows authentication ( this error appears "login failed for (domain/user)" ),while no problems happened in the connection when i would to connect to other servers at other locations(to cities b,c) via windows authentication.

note that i can access to (city a)server via sql server authentication , but i want to access to this server(city a) via windows authenication as the other locations because this authentication mode is policy of our system, and note also that persons in city b can access to all servers (city a,c) via windows authenication .

regards,

View 2 Replies View Related

File Extension For Sqlserver2000

Oct 25, 2006

Hi,

If access database has an extension of .mdb then what is sqlserver2000 file extension?

View 1 Replies View Related

Optimizations Job Failure - SQLServer2000

Jun 30, 2004

Hi all,
I created a database maintenance plan with backup + transsactionlog backup+optimizations. The first two jobs work fine but the Optimizations job is failing with error:
sqlmaint.exe failed. SQLSTATE 42000, Error: 22029. The step failed.

User is admin on local box and "sysadmin" in db server role. Any suggestions to resolve this?

Thanks
Vinnie

View 1 Replies View Related

Enterprise Manager SQLServer2000

Jul 16, 2004

When I click on Enterprise manager->Database this is the error I am getting:
A runtime error has occurred. Do you wish to debug. Line 306 Error: unspecified error. Yes/No

This is happening on user databases only not the SQL standard dbs; pubs,master,northwind.

How can I fix this?

Thanks for any help.
Vinnie

View 4 Replies View Related

Error On Win98 And Sqlserver2000

Aug 23, 2006

Wilson writes "Hi, I have Sql Server 2000 on win98, i can't retrieve any data. Instead, it shows an error, says that some files is missing or is not registered.

the mssql was reinstalled and it's goin then same.

what could be the problem? what could be the solution?"

View 1 Replies View Related

Indexing Newbie - SQLServer2000

Jan 8, 2008

Hi All,

I understand I can use Index tuning Wizard to index a DB. I understand as well I have to feed it with a workload file, which is a collection of queries. I do have a limited number of stored procedure (150-200 in total) being constanlty executed against this DB (around 700MB).

Can I generate a workload file with these storedprocedures optimizing so the DB for their execution?
If yes, how? can someone point out some good tutorial about this?

Any help would be much appreciated,

JI

View 9 Replies View Related

SqlServer2000: Autonumbering Records - How To ?

Jul 23, 2005

I created table with "id" field as "uniqueidentifier" (primary key).I connect via ODBC from MS-Acces.-->>> Don't know how to something like "Autonumber" in MS-Access.Let me know If any trigger or something like this is required.Please post some code of trigger if need.Until now I have only developed some native MS-Accessdatabases. I hope there is some solution about "Autonumbering records"in SQLServer.SqlServer 2000, Access Xp.Marek B±bski

View 2 Replies View Related

How To Encrypt Database In SQLServer2000, Please Help Me, Thanks

Dec 26, 2005

I have 2 questions:

1. How to encrypt data of database in SQL Server 2000 ? Someone can't see true data

if without password or something else.

2. If i have 2 database . All of them have same table, structure, ....How to update or insert or change in the second database when i update or insert or change in the first database automatically ?

Thank you very much.

View 10 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved