Server Level Permissons

Aug 1, 2006

Recently put together a new Win2003 (R2) development server, which will be used to host SqlExpress databases, both for development and some domain users within the organization. Don't have a lot of Win server level expertise, but did manage to get SqlExpress up running and configured for remote usage. Created a db login/user account and was able to get a VB6 application connected to the database with one caveat -- I could connect to the db only as part of the local Administrator group of that server. Taking myself (or anyone else) out the Adminstrator group keeps me from connecting remotely to the database through the application. I can connect to the db remotely through Sql Express Manager using Sql Server authentication. The app itself uses Sql Server authentication, but can't seem to establish a remote connection unless I'm administrator.

Could someone please clue me in as to how to set server level permissions for specific users (or domain of users), so that the remote application can connect and open the database. I've tried setting folder level permissions on the server to no avail, and don't know how this is normally done for a Sql Server database.

Supplement: the acutal error message I get is:
Cannot open database requested by the Login
Source: Microsoft Native Client

TIA,

Rick

View 4 Replies


ADVERTISEMENT

Bypassing Object Level Permissons

Mar 30, 2000

Hi all,

I have created a login with just select permisson, I also want to give permisson to truncate a table (not delete) , for that reason I had to create a stored procedure.

CREATE procedure Sp_truncate as

truncate table Zip_Code_Lookup

I gave execute permisson for the stored procedure , but when I run this Stored procedure I get the following error
Only the owner or members of the sysadmin role can truncate table 'Zip_Code_Lookup'.

Any help would be appreciated

Thanks Again

View 2 Replies View Related

Grant Permissons

Jan 22, 2001

Hello All,

I have 2 logins

1. Login1 ( has dbo permissons)
2. Login2 ( Data reader )

I have Created a table Tbl1 using Login1 ,

I have used grant statement to give select permissons to Login2

When I connect to the database using Login2 and use the T-Sql :- Select *
from Tbl1 , I get an error saying Invalid object name 'Tbl1'.

Thanks in Advance

View 2 Replies View Related

Column Level Or Database Level Encryption/decryption....

Jan 16, 2008

I want to perform column level and database level encryption/decryption....
Does any body have that code written in C# or VB.NET for AES-128, AES-192, AES-256  algorithms...
I have got code for single string... but i want to encrypt/decrypt columns and sometimes the whole database...
Can anybody help me out...
If you have Store procedure in SQL for the same then also it ll do...
Thanks in advance

View 1 Replies View Related

High Level && Detail Level Design Documents

Nov 19, 2007



Hi,
AM in need of SSRS 2005 design documents for a project purpose. Can somebody let me know where can i find these documents? Thanks in advance

View 1 Replies View Related

Server: MSg 17, Level 16, State 1 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server Does Not Exist Or Access Denied

Jun 6, 2007

Hi,

When I am trying to access SQL Server 2000 database from another machine i got this error

Server: MSg 17, Level 16, State 1 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied

but I could access the database on same server and in that server i could access other databases in different server.



View 6 Replies View Related

Transactions = Table Level Or Row Level ?

Nov 29, 2006

When you utilize transactions in ADO.NET are the locks put on the entire TABLE used or at the row level?
For instance if you do a SELECT within a transaction if you only pull 5 rows out of a 1000 row table can you just make it lock the rows that have been pulled?  It seems like it locks the entire table?
 
Thanks

View 6 Replies View Related

What Is Low Level And High Level Locking

May 3, 2007

Hi, Can anybody please explain me, what is low level and high level locking in SQL Server 2005 database.
Also what is the name of process which converts low level locking into high level locking and vise versa.
-Sanjeev

View 2 Replies View Related

Statement Level Vs. Row Level Triggers

Jul 20, 2005

Hi..I'd very much appreciate it if someone would tell me how to translatea statement level trigger written in Oracle to its equivalent (if there isone)in MS SQL Server. Ditto for a row level trigger.If this is an old topic, I apologize. I'm very much a newbie to SQL Server.Regards,Allan M. Hart

View 2 Replies View Related

Query Analyzer Error Unable To Connect Server Local Msg17, Level 16,state 1/ODBC SQL Server Driver [DBNETLIB]SQL Server Does Not

Oct 20, 2007

I am getteing
need help
Query analyzer error Unable to connect server local Msg17, level 16,state 1
ODBC SQL server driver [DBNETLIB]SQL server does not exist

View 6 Replies View Related

SQL Server Admin 2014 :: Server Level Trigger To Log Activity And Rollback After Logging Information

Sep 8, 2015

I use following trigger to stop user "smith" if he try to connect through SSMS to My Server:

create TRIGGER [trg_connection_MyServer]
ON ALL SERVER WITH EXECUTE AS 'Smith'
FOR LOGON
AS
BEGIN
IF ORIGINAL_LOGIN()= 'Smith'
begin
if exists (SELECT 1 FROM sys.dm_exec_sessions
WHERE (program_name like 'Microsoft SQL Server%' and original_login_name = 'Smith') )
ROLLBACK;
end

I want to log this information or send emal incase, this user try to connect through SSMS, so that I can catch it. How can I do this, if I use insert command it rollsback everything and I can't do any activity.

View 8 Replies View Related

SQL Server 2000 Server: Msg 18456, Level 14, State 1, Line 1 Login Failed For User 'sa'.

Feb 28, 2007

As an 'SA' I thought that you have permission to do anything on the server. Running an update command from Query Analyzer is throwing this error:

SQL Server 2000 SP3

Server: Msg 18456, Level 14, State 1, Line 1
Login failed for user 'sa'.


The table is in the dbo schema.

Has anyone seen this error before?

View 12 Replies View Related

Server: Msg 207, Level 16,

Aug 21, 2004

In a Stored Procedure, I created a table in code:

CREATE TABLE TEMP ( ...)

, then ALTER TABLE TEMP ADD int1 int, varchar2 varchar(25)

I inserted some rows to the above table. Everything looks good.

Here's what puzzled me:

SELECT * FROM TEMP shows all the rows inserted.

But

SELECT int1, varchar2 FROM TEMP caused this error:

Server: Msg 207, Level 16, State 3, Line 5
Invalid column name 'int2'.
Server: Msg 207, Level 16, State 1, Line 5
Invalid column name 'varchar2'.

Thanks for any help.

View 1 Replies View Related

A Transport-level Error Has Occurred When Receiving Results From The Server. - After Installing New Instance Of SQL Server 2005 W/NO App Changes

Sep 27, 2006

We've devoted a resource to this today, but I have to believe it's something easy that we're overlooking.  The scneario is that we have a production Web application that until last weekend had a SQL 2000 back end.  This weekend we installed a new instance of SQL 2005 and everything works (we tested in a sandbox environment, but someone must not have load tested enough) and never saw these exceptions.   So, after the upgrade we now receive 100's of thexe SQL excptions per day:A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)Does anyone know what we've overlooked that's causing this issue?Thanks for any help! 

View 2 Replies View Related

SQL Server Admin 2014 :: Audit All Server DDL Level Events?

Mar 6, 2015

I have been tasked with auditing all DDL and selected DML events on a production server and logging them to a table. My solution is to use CDC for the DML and a Server-Level trigger for the DDL. Because there should never but much DDL activity on the server (except when performing update tasks) I don't need to worry about the trigger consuming too many resources.

My question is this: Is there any single specification such as DDL_LEVEL_EVENTS that can capture all DDL activity or do I need to specify each and every DDL action in the trigger?

View 1 Replies View Related

SQL Server 2000 - Server: Msg 9002, Level 17, State 6, Line 1

Jul 20, 2005

I have a stored procedure that takes 18 hours to complete. SometimesI get the below error message when I run the stored procedure.'Server : Msg 9002, Level 17, State 6, Line 1 The log file fordatabase 'Customer' is full. Back up the transaction log for thedatabase to free up some log space.'.I checked my log file and it is not full. And I don't know why I amgetting this message. Any help is appreciated.Thanks,Anjula

View 2 Replies View Related

How Do I Do Row Level Locking In The Sql Server?

Apr 6, 2001

View 2 Replies View Related

Server: Msg 229, Level 14, State 5???

Jun 23, 2000

Server: Msg 229, Level 14, State 5, Procedure sp_monitor, Line 167
EXECUTE permission denied on object 'sp_monitor', database 'master', owner 'dbo'.


How do I fix this? which roles, or permission is that? Is there a
easier way to find out solutions for these problems, as books online
does not seem to provide much help.

Thanks,

Vijay

View 2 Replies View Related

Server: Msg 11, Level 16, State 1

May 13, 2008

IN THE SQL SERVER 2000 AND IN ALSO IN 2005 WHEN GOING FOR THE LOGGING IN TO THE SQL SERVER USING A PUBLIC IP, AND GIVING THE SQL SERVER AUTENTICATION IT IS GIVING THE FOLLOWING ERROR

Server: Msg 11, Level 16, State 1[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation.

THE SAME ISSUE HAPPENING WITH THE ODBC CONNECTION. CAN ANYONE EXPLAIN ME WITH THE FOLLOWING ERROR

DO NOT GIVE A SUGGESTION OF REINSTALLATION, BECAUSE TRIED THAT ONE TOO

REGARDS

CHAITANYA BABU YANAMADALA

View 2 Replies View Related

Server: Msg 209, Level 16, State 1, Line 6 HELP

Jun 7, 2005

Simple SQL Error Can anyone help for a new starter. Error MessageServer: Msg 209, Level 16, State 1, Line 6 Ambiguous column name 'CustomerID'.Codeselect CustomerID, ContactName, OrderId from CustomersInner Join Orders OnCustomers.CustomerID = Orders.CustomerIDDBMS = SQL Server 2000 SP 3aDatabase = NorthwindI have no idea why i receive this error

View 1 Replies View Related

SQL Server Field Level Encryption

Sep 16, 2005

Where can I get some information on field-level encryption in SQL Server?  My users will be installing my ASP.NET app on a laptop and taking it out "into the field".  If it gets stolen they want some safeguards.I've suggested that they encrypt the hard drive and things, but they want field-level encryption for the data.  I know how to do things like hash a password, but that doesn't help with retrieval.  I have to be able to search on and decode the data.  For example, I have SSN as a field.  I need to be able to search on SSN, display it to the user, and allow them to change it.The other problem is partial searches.  If I encrypt SSN in the database then I can probably just search on the hashed value, but if I want to search on "smith" and get all of the smiths, smithes, etc., then I can't search on the encrypted value.  I have about 1 million records, so decrypting each name to do the search would be prohibitive.Anyway, I'm sure this has been done, so if there is a thread or a site that discusses this I'd be willing to read up on it.

View 1 Replies View Related

Column Level Permissions For Server 7

Jun 24, 2000

Is there a graphical tool to manage column-level permissions just as it was possible in Enterprise Manager for Server 6.X ?

View 1 Replies View Related

Server: Msg 536, Level 16, State 3, Line 1

Mar 16, 2001

Hi, I would appreciate your help. I donot know why I am getting this error when I run this query :
if (select SUBSTRING(de_ftpdownload,1,CHARINDEX('.',de_ftpdow nload,0)-1)as de_ftpdownload from vendor_invoice)
<> (select stamp_number from vendor_invoice)
select 'no'
else
select 'yes'

I get this Error
Server: Msg 536, Level 16, State 3, Line 1
Invalid length parameter passed to the substring function.
----
yes
(1 row(s) affected)
I would appreciate your hlep

Al

View 1 Replies View Related

Server: Msg 107, Level 16, State 2, Line 1

Jun 23, 2004

Can anybody help me with this syntax?
select
PHN.N_PHN_ID 'ID',
PHN.N_PHN_AREACD 'AREAD1',
PHN.N_PHN_PREFIX 'PREFIXD1',
PHN.N_PHN_NUMBER 'NBRD1',
PHN.N_PHN_EXTENTN 'EXTD1',
PHN2.N_PHN_AREACD 'AREAD2',
PHN2.N_PHN_PREFIX 'PREFIXD2',
PHN2.N_PHN_NUMBER 'NBRD2',
PHN2.N_PHN_EXTENTN 'EXTD2'
from Donor_Visit2 DV2 RIGHT OUTER JOIN NAT_PHN_DB_REC PHN
ON DV2.COUNT_INSTID = PHN.N_PHN_INSTID
RIGHT OUTER JOIN NAT_PHN_DB_REC PHN2
ON DV2.COUNT_ID = PHN2.PHN.N_PHN_ID
order by PHN.N_PHN_ID

here is the error message:
Server: Msg 107, Level 16, State 2, Line 1
The column prefix 'PHN2.PHN' does not match with a table name or alias name used in the query.

View 1 Replies View Related

Server: Msg 208, Level 16, State 1, Line 1

Nov 22, 2004

Hello All,

This table was created by coldfusion and has been given all priviliges to public and I am in the public group but I still cant select from it. It gives me this error message: Server: Msg 208, Level 16, State 1, Line 1. Help!

Thanks in Advance.

View 5 Replies View Related

SQL Server 2008 :: Parsing Out XML On Same Level

Aug 20, 2015

I am trying to parse out

<Discharge_x0020_Time>
<time>
<Hour>11</Hour>
<Minute>:00</Minute>
<AM_x002F_PM>AM</AM_x002F_PM>
</time>
</Discharge_x0020_Time>

Into Hours, minutes, and ampm

I use

Select...
,DISCHARGEHOUR.value('(./Discharge_x0020_Time/time/Hour)[1]', 'varchar(10)') AS [hour]
,DISCHARGEMINUTES.value('(./Discharge_x0020_Time/time/Hour:minute)[1]', 'varchar(10)') AS [Minutes]
,DISCHARGEAMPM.value('(./Discharge_x0020_Time/time/Hour/minute/AM_x002F_PM)[1]', 'varchar(10)') AS [ampm]

FROM ...
CROSS APPLY data.nodes('/Data') a(DISCHARGEHOUR)
CROSS APPLY data.nodes('/Data') b(DISCHARGEMINUTES)
CROSS APPLY data.nodes('/Data') b(DISCHARGEAMPM)

But minutes AND AMPM come up as NULL I assume I am setting up something wrong with the level on minutes AND AMPM. Also, can I disregard the ":" in the minutes.

View 1 Replies View Related

Row Level Lock In Sql Server 2000

Feb 23, 2006

Devteam writes "Hi,
WIndows version 5.0 (SP4)
I am using sql server 2000. in our application i am using simple select statement to retrieve the value from the database. Sometime the same query is accessed i did not get the result.i have tried to run the same query using query analyzer. but the query is keep on running. at the same time when accessing other rows in the table, it gets retrieve the values.

what is the problem here... is there anything locked that the row before executing the select statement.
if there is any lock is present then how to identify it and also how to prevent a row from locking... if the lock is occured then the other transactions also not executed. why the lock is placed in the first place."

View 1 Replies View Related

Sql Server 2005 &#043; Row Level Trigger

Jul 18, 2006

hi
i want to know if row level trigger works with sql 2005.
because in 2000.. only statement level trigger was used.

Thks in advance.

View 3 Replies View Related

Sql Server 2005 &#043; Row Level Trigger

Jul 19, 2006

hi
actually i have a temporay table wich has four columns
say col_1,col_2,col_3,col_4.
so firstly i wud bulk insert from a text file wich mite contain thousands of rows.
then from this temp table col_1 and col_2 shd go to master_a.wich has an identiy column as primary key.
say id,col_1, col_2.

i will have another table detail_b where in there is a foreign key to the table master_a for id.
so it will have f_id, col_3,col_4.

so i am riting a trigger on master_a. so whenver row is inserted in master_a. coresponding id and col 3 col4 shd be inserted into detail_b.

For this in oracle we have row level trigger. where in for each insertion in master a .. correspoding trigger will fire but in sql 2000..
but i wud like to implemtn row level trigger..
can u hlep me out..

View 1 Replies View Related

Intercept SQL : Spy / Driver-level / SQL Server Log...

Jul 20, 2005

Hello all,We need to reverse engineer a very large application written inPowerBuilder / SQL Server to port to .NET.We have only binaries of application not source code.What are tools / log facilitites / spy appliations that shall allow usto see exact SQL that is being carried by driver to SQL server ? Canwe see that in the ASCII form before it gets complied at Server end?Thanks for your time.- KA

View 1 Replies View Related

Determing SQL Server Patch Level

May 12, 2008

Sort of new to MSSQL and I have a problem with my maintenance script not deleting files on 2 out of 3 servers so I am trying to determine what patch level I am at.
'Server A' works as expected:

Microsoft SQL Server 2005 - 9.00.2050.00 (Intel X86)

Feb 13 2007 23:02:48

Copyright (c) 1988-2005 Microsoft Corporation

Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)


These two servers don't:
Server B.

Microsoft SQL Server 2005 - 9.00.2050.00 (Intel X86)

Feb 13 2007 23:02:48

Copyright (c) 1988-2005 Microsoft Corporation

Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)


Server C.
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)

Oct 14 2005 00:33:37

Copyright (c) 1988-2005 Microsoft Corporation

Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

So I can see where I should patch server B to SP2 but why does Server C report as 9.00.1399 SP2?

View 5 Replies View Related

Server: Msg 18452, Level 14, State 1

Jul 18, 2007

Hi All,

I am facing a very strange problem in one of my SQL2000 instance.

Actually, In one of my 2000 instance 'A', I have linked another 2000 instance 'B' (server 'B' is running under windows authentication) and I am a member of a group (SQL_Group) and that group is listed in sysadmin of both 'A' and 'B' Instances. When I am trying to run a simple select query from server 'A' to linked server 'B'

i.e. select top 2 * from [<Server_Name> <Instance_ Name>].master. dbo.sysobjects

It is giving me an error.

Server: Msg 18452, Level 14, State 1, Line 1
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.

But rest of the members of same group (SQL_Group) are able to execute this query. Can anyone please let me know why this issue is only for me even I am having the same permissions as others??

Any help will be highly appreciated. thanks a lot to all of you.



Rizwan...........

View 2 Replies View Related

Compatibility Level SQL Server 2000 (80)

Jan 6, 2006

Hallo Everyone,

I have an SQL database that I need to detach from an SQL2005 server and reattach to an SQL 2000 database. I tried to set the Compatibility level from SQL Server 2005 (90) to SQL Server 2000 (80). This did not work

Any ideas?

Nigel...

View 12 Replies View Related







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