| SQL Server Security Interview Questions |
|
|
can anyone tell me , i setup sql server 2005 on windows vista
and it's not able to create any new databases telling me "CREATE DATABASE PERMISSION DENIED in master " !!!!!!!!!! i dunno wass wrong with it
|
|
|
|
Hi guys.
I have a problem connecting my database in vb.net through the Data link properties.
Im using vb.net 2003 and SQL server 2000.
before, everytime I try to select the database files that I will attach to VB, I kept on getting the error message that the file is in use. heck. I dunno where it was used. I have here in my vista before a vb.net express edition, vb.net 2003, sql server 2005, and sql server 2000. as first, I thought that the sql server 2005 was making the error. I uninstalled it. also the vb express edition. But I still get the same error message. I uninstalled the other two (vb.net 2003 and SQL server 2000) and reinstalled them. Now, when I select the database that I will connect, I get this darn error message: "<databasename> You don't have permission to open this file. Contact the file owner or an administrator to obtain permission."
What should I do about this. Please can anyone help me about this one.
btw, I'm working on a laptop with Vista as my OS.
I've tried connecting databases with my desktop with XP as its OS. They work just fine.
I need to fix this problem on my laptop. This is what I'll be using to present our computerized system. please help. I'm running out of time.
Thanks in advance.
|
|
|
|
I am using SQL Server 2000. I wanted to send MIME type mail through SQL Mail. So I downloaded xpsmtp80.dll and copied to C:\Program Files\Microsoft SQL Server\MSSQL\Binn\DLL. Then I registered it by exec sp_addextendedproc 'xp_smtp_sendmail', 'xpsmtp80.dll'. I granted permission to public by grant execute on xp_smtp_sendmail to public.Now when I am executing this
declare @rc int
exec @rc = master.dbo.xp_smtp_sendmail
@FROM = N'MyEmail@MyDomain.com',
@TO = N'MyFriend@HisDomain.com',
@subject = N'My first HTML mail',
@message = N'<HTML><H1>This is some HTML content</H1></HTML>',
@type = N'text/html'
select RC = @rc
go
An error generating stating
ODBC: Msg 0, Level 16, State 1
Cannot load the DLL xpsmtp80.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
(1 row(s) affected)
Please anyone help me to sort out this problem.
|
|
|
|
I have SQL Server 20005 express on Windows Vista and I'm trying to make a new database but I get an error: Create database permission denied in database 'master'. Why do I get this error? I'm the admin, there's only my account on the computer anyway. I had the same edition of SQL on my old computer with XP on it and I never had any errors. Is there something I should do differently in Vista?
|
|
|
|
Anyone know how to add the iusr account to an sql server database and assign it read/write permissions?
Thanks
|
|
|
|
I'm trying to run SQL Server Agent and SQL Server Service under a NT domain account. From there I would like to associate these domain accounts to locally defined security groups. How can I know for sure which parts of the OS (Windows 2003 Server R2) that these services are going to access so I can add the correct permissions to my local security groups?
|
|
|
|
I installed sql server in a windows 2003 system. I want users to connect to this server system and can work in databases. I want to create user accounts in sql server for users to connect to the server and access the database. I want to give permissions to users like
* they should not create their own logins * they should not delete databases or drop databases. Please help me in doing all theese. Which software should i install in client system so that to connect to the server do their work.
|
|
|
|
I am trying to ASP.Net to sql server 2005 thro oledb or sql adapter...but when i run Login failed "servername/asp.net" error message has beeb displayed.Do i need to add permission in sql server?
|
|
|
|
I have developed a web based php survey and the results are stored in a SQL database. Is there a way to set up user permissions in either the database or php code? For example, we have clients, sales people, and supervisors. I want the sales people to only view their clients responses (not be able to see other sales peoples results), and for supervisors to only view their sales peoples results. Is this possible? If so, please point me in the right direction.---Thank you!
|
|
|
|
I have an application role with SQL Server 2000 that is granted permission to a certain table and seemingly on random days the permission I give to that application role disappears just on one table. The application role works fine on all of the other tables.
To my knowledge there are no triggers or other stored procedures that access this table. Anyone ever have this problem, and more importantly, how do I fix it?
|
|
|
|
I'm running vista and I have Visual Studio 2008 installed. In the process of installing sql server 2005 sp2, the installation said that I already the application installed, so I canceled the install. I then installed management studio with no problems. When I tried to create a new database, I received the above mentioned error. Help!
|
|