Recent update: 2008-3-21
554 byte By
guest at 2008-3-8
When I try to Connect to SQL Server By Win App this Error happens But when I connect by Server Explorer In VS 2005 this connect to SQL Server 2005 Express Edition(My SQL Server Set to Mixed mode Authentication.)System.Data.SqlClient.SqlException was unhandled Class=14 ErrorCode=-2146232060 LineNumbe...
(Cross post from newsgroup) Attempting to implement Windows authentication between trusted domains. . . I have a domain trust set up between two domains connected via persistent vpn: REMOTE and HQ sqlserv is: HQ\SQLSERV (SQL 2000 server) client machine is: REMOTE\MACHINE1 (SQL 2005 tools) I ...
(Cross post from newsgroup) Attempting to implement Windows authentication between trusted domains. . . I have a domain trust set up between two domains connected via persistent vpn: REMOTE and HQ sqlserv is: HQ\SQLSERV (SQL 2000 server) client machine is: REMOTE\MACHINE1 (SQL 2005 tools) I ...
If a user is a local admin of the box they can gain full access to the database via integrated security. They can create their own database and attach .MDF How can i secure the .MDF so that no one can gain access to it?
541 byte By
guest at 2008-3-5
I have the problem with login to SQL Server 2005 Express Edition .The SQL Server is Set to windows and SQL Server Mixed Authentication Mode . I had Create SQL Login and User in my database . When I try to connect to SQL Server usingcredential with "ConnectionString" in my Win Application ,...
I'm trying to set up Service Broker Services on SQL 2005 x86. I've got two services set up, and a stored procedure associated with one of them.The stored procedure is going to execute a query against a database on another server running SQL Server 2000 SP3.I can get the stored procedure to ...
818 byte By
Tjam at 2008-3-1
We have a web app that accesses Sql Server 2000 using windows authentication. We recently installed SQL Server 2005 on a new server and are in the process of porting the data from SS2000 over to 2005. I expected some problems, but I've run into something that seems like it should be relatively ...
268 byte By
KarloS at 2008-2-28
Hi. I am running SQL select queries over a network from a SQL Server to a mySQL server by creating a linked server. I need data to be encrypted (nothing heavy), but some form of encryption over the network as it exits the firewall. Any help appreciated. Karlo
977 byte By
Fipil at 2008-2-27
Hi,please, I was imported X.509 certificate from the .cer file into a database, using command:CREATE CERTIFICATE FROM FILE='c:\temp\testCert.cer';After this, I found this certificate in the sys.certificates view.Now I want to write managed user defined function (.net managed code), which uses ...
When will there be a version of MBSA that does the SQL Server checks for SQL Server 2005. MBSA 2.0 does not. Thanks, Sharon
9829 byte By
Fipil at 2008-2-25
Hi!I'm working on the following application:In the client application (written in C#) an user signs a document by private key, stored on chip card. Signed document and the signature are stored into database on SQL 2005 server. There is my client code for demonstration: Client application ...
I was trying to install Business Scorecard Manager Server , for that i have installed SQL server 2000, Analysis services and Service Pack 4 and also have taken mixed mode of authentication . Then i have installed sharepoint portal server 2003 and extended a site . Now when i install BSM server ...
353 byte By
Dim at 2008-2-23
Dear all,I have views in database that select records from a table in another database in the same server. Can I set security in such a way for not to give direct access to the table. I know than it is possible if a table and views are in the same database and have the same owner, but I failed ...
Hi,i'm working on the rtm version of mssql 2005 and i'm wondering to find that the database list are hard coded into SQL Server Management.I need to hide databases list for (newbie) users on EM 2000 i can hide this list using this kb http://support.microsoft.com/?id=889696 but on the new ...
Hello,I have a hard time understanding a security problem with SQL Agent.I have jobs that run SQL only ssis packages and ssis packages that access external databases like Oracle and older SQL boxes.For the sql only package, I can use the SQL Agent Service account however for the ssis that ...
1165 byte By
Codoc at 2008-2-21
I am designing my software to be 'secure by default'.I only grant permissions to entities that actually require them, to help prevent unexpected attacks like injection attacks. To do this, I have a SQL script that configures all the permissions on my database. It is basically a series of ...
The following question may be trivial, however, I just can't make it clear to myself, even after reading through the Books Online.I have two machines in the same network.A hosts Sql Server (named AS), B access the database ASD in Sql Server AS.A has windows logon info as UserA and PasswordA, ...
456 byte By
Abhi_7 at 2008-2-20
Microsoft recommends using Windows authentication instead of SQL Server authentication in SQL Server 2005 for improved security. What are the Microsoft best practices for implementing this? Will be helpful if someone also provides some links that talks about this.... ...
Hi, In SQL Server Express Edition, what are the rights that are assigned to a Normal Windows User and PowerUser by default ? When I install SQL Express on a clean machine and login as Power User I can add/edit/delete data but when I login as Normal Windows User I can see the data but not ...
Hello!I've just installed SQL Server 2005 CTP and now I have a question. If I open any database properties window, click "Permissions" tab in the bottom grid (under the title "Explicit permissions for...") I see several columns and one of them is "With grant". When I click a check box in this ...
269 byte By
KarloS at 2008-2-18
Hi. I am running SQL select queries over a network from a SQL Server to a mySQL server by creating a linked server. I need data to be encrypted (nothing heavy), but some form of encryption over the network as it exits the firewall. Any help appreciated. Karlo
Hi folks, I′m brazilian and new in SQL Server.Now i′m justing tryng to create a instance to use with WSUS.I Already created but when i try to install the WSUS and its try to connect into my new instance, i received the message:Failed to connect to sql server ... Class not registered.Could you ...
Hello,I need an email extractor which can extract me the email address from the specified ebay user I need.To give you a clue here is what I need.On ebay you know every user is registered with an email address but lately you cant view their email address.If any can make a program which can extract t...
I can't define a linked server in SQL Server 2005 x64 edition (to a SQLServer 2000 instance).The error message is :OLE DB provider "SQLNCLI" for linked server "serv01" returned message "Unspecified error". OLE DB provider "SQLNCLI" for linked server "serv01" returned message "The stored ...
Hello,I'm use SQL Server Mobile on desktop to create and populate an .sdf file.Everything has been working very well; however I just encountered an issue when I try to create or use the database in any way I receive the following message.The operating system does not support encryption.My ...
In SQL Server 2005, you must have the VIEW SERVER STATE permission in order to access sys.syslockinfo ( http://msdn2.microsoft.com/en-us/library/ms189497).It seems that the VIEW SERVER STATE permission can only be granted to users.Once you execute sp_setapprole, the connection loses the ...
246 byte By
ceto at 2008-2-15
I forget my dts password for an dts on Sql 2000 SP3 .How can i reset or find my password for edit my DTS .I have db admin and sys admin user rights on this database. thanks for your help. ?zgür ?etiner ozgurcetiner@hotmail.com
We are releasing an application built on SQL Server Express in the next few months. Our clients are mostly small companies with little technical knowledge, and they will be using our application on desktop computers where everyone likely logs in as the same user. As such, my thinking is that we ...
We have 2 failover servers and one client in our test environment. We have all the three configured in mixed mode authentication(windows + sql server authentication). But when we are failing over from 1st server to 2nd one, we are getting the following error message,'Unable to connected to ...
I understood that sql 2005 has EncryptByCert(varchar) function to encrypt data field. but varchar is limit by 8,000 chars long.My question is:as sql 2005 built in function, is there any way to encrypt a text or varchar(max) fieild which could be more than 8,000 chars?Thanksduohong ...
715 byte By
Newsco at 2008-2-14
We are trying to link an SQL2K server (Running in mixed mode) to an SQL2K Server (Running in Windows only mode).In the properties I have tried putting (in Local server to Remote server mappings on the security page)my own dm\JohnDoe to dm\JohnDoe as both servers are in the same domain. In ...
I was under the impression that Management Studio wouldn't list any databases that a user doesn't have access to. But if I create a new user and give them db_owner permissions to just one database, if they log into Management Studio, they are able to see all databases listed. They don't have ...
I know this is probably a question that has been answered a million times, but it is in regard to SQLEXPRESS. I have built a small ASP 2.0 web app that runs fine on the local production machine when I go to view a gridview or a detailsview to delete or add records. However, when I try the site ...
Hi, Is there a way that I can enable/disable logins using SQL Authentication? Or similar function like Oracle's ALTER user LOCK/UNLOCK. Thanks & Regards. Dennis
I've been experimenting with the new column-level encryption features in SQL2005. While it's been very handy, I'm somewhat concerned about its performance impact -- particularly when there are many columns involved. Is there any known method for SQL2005 to use a hardware crypto accelerator ...
Hi, all. I've got a question that's truly newbie. I've added logins to the "users" of a database, but I've never used the "roles" area. What's the difference? Is a role like a group account with some preset permissions? We've got a user who needs read-only access to a database and I ...
I have a server with SQL Server installed first, and MSDE installed later. Both are set to Mixed mode. The operating system of the server is Windows XP Sp2.I opened the port for SQL Server 1433, and MSDE port 1503(get from registry) in the Windows Firewall, and enable DISABLENETWORKPROTOCOLS=0 ...
I can not delete user from a database in sql2005 beta 3.the message errror is :TITLE: SQL Server Management Studio- Drop failed for User 'Amministratore'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft SQL ...
The following question may be trivial, however, I just can't make it clear to myself, even after reading through the Books Online.I have two machines in the same network.A hosts Sql Server (named AS), B access the database ASD in Sql Server AS.A has windows logon info as UserA and PasswordA, ...
Thought I edited a previous post but apparently not. The cannot view problem is with a png file inserted on a start page of a web site. Other Gif and Jpeg files are viewable with IE and Mozilla but not the png file.
761 byte By
el33 at 2008-2-7
Hello, this is my first time posting here. I've never really worked with SQL Server much, but I'm in the process of learning. Please forgive my ignorance. Anyways, here's my dilemma. A user at the office uses Crystal Reports (I'm not too familiar with this program either). Crystal Reports ...
Hello All, I have SQL Server 2005 Installed and i have numbers of SQL Logins users which i want to use in my ASP.Net Application for authentication.I am using ASP.Net 2.0 (VS.Net 2005). Can i use the SQL Logins for ASP.Net web application authentication like the way we use Active Directory ...
412 byte By
N.S. at 2008-2-7
After upgrading to CTP16 (Sept.), I can't seem to debug my script task. Everytime I run the package with a breakpoint in script task I get following error: "SQL Server Integration Services Script Task has encountered a problem and needs to close. We are sorry for the inconvenience. "If I ...
Does anyone know how to impersonate a user and then use integrated security with SQL server? Every place I've looked so far only shows how to use integrated security through IIS. For some reason, everytime I impersonate a user account, SQL server identifies me as "NT AUTHORITY\ANONYMOUS LOGON" ...
I have a group login created on the SQL server like so:CREATE LOGIN [MyDomain\MyGroup] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english]I have then created a user in the db MyDB for the login above and gave it db_owner role:use MyDBgoCREATE USER myDBUser FOR LOGIN ...
436 byte By
hafi at 2008-2-5
in SQLServer2005 how can I allow update system catalogs (by mouseclick)? sp_configure 'allow updates', 1 - works, but I get the message Msg 259, Level 16, State 1, Line 1 Ad hoc updates to system catalogs are not allowed. ...
I am trying to set up a secure system and would like some advice on how to do it as it is a bit tricky.The underlying security is Windows Authentication but I need to set various permission levels in the application.What I want to do is to allow users read-only access to a users table. Once ...
2195 byte By
xsc at 2008-2-4
Hi, can someone help me on thisI have two servers linked with each others - ServerA and ServerB. ServerA located in trust area while ServerB located in DMZ behind firewall.I am able to run query from both servers without performance issue. However, when I start using BEGIN TRAN or BEGIN ...
Hello All, I have SQL Server 2005 Installed and i have numbers of SQL Logins users which i want to use in my ASP.Net Application for authentication.I am using ASP.Net 2.0 (VS.Net 2005). Can i use the SQL Logins for ASP.Net web application authentication like the way we use Active Directory ...
659 byte By
2Steps at 2008-2-4
hi,I have two computers on my network, on is my working computer and the otherone is my database server. i want to configure my database server in such a way so that it should be connected from any remote location through its IP.it is working fine when i connect my database server with my local ...