SQL Server does not exist or access denied.
Thu, 3 Apr 2008 12:00:55 -0700 (PDT)
I get this error message with SQL Server 2005 on an XP Pro machine. I
don't need network access - the intention is a single user on a single
machine.
I can log in using the management studio with no problem .
I get this error message when I try to create an ODBC connection. I
have tried both <mymachinename> w ...
|
Find users IP address
Thu, 3 Apr 2008 09:08:00 -0700
Is there any way to write a script to find a users IP address or computer
name the way that Citrix does if running through a web app ...
|
XP_Cmdshell
Wed, 2 Apr 2008 11:45:01 -0700
Hi there,
I have a question on the xp_cmdshell, if deleted from SQL Server could it be
recreated again in SQL2000 & SQL 2005, I am aware that in SQL2000 its enabled
by default but 2005 its disabled but can be enabled by sp_configure '1'.
My main concern is when this sproc is deleted , would it affect any oth ...
|
MBSA 2.1 Beta Reports: Issue: Public Permissions
Wed, 2 Apr 2008 11:43:01 -0700
Issue: Public Permissions
Score: Check failed (critical)
Result: The following databases have public access.
Remove the public access if it is not required - tempdb , model , msdb.
How do i resolve this? ...
|
MBSA 2.1 Beta Reports: Issue: Public Permissions
Wed, 2 Apr 2008 11:43:01 -0700
Issue: Public Permissions
Score: Check failed (critical)
Result: The following databases have public access.
Remove the public access if it is not required - tempdb , model , msdb.
How do i resolve this? ...
|
MBSA 2.1 Beta Reports: Issue: Public Permissions
Wed, 2 Apr 2008 11:43:00 -0700
Issue: Public Permissions
Score: Check failed (critical)
Result: The following databases have public access.
Remove the public access if it is not required - tempdb , model , msdb.
How do i resolve this? ...
|
How to add a login with Win XP Home workgroup and without domains.
Wed, 2 Apr 2008 04:45:03 -0700
How to add a login to MS-SQL Express installed at WIN XP Home, in a workgroup
in which domains has not been set up? "Search" shows only users from computer
where server was installed, but not others in workgroup. ...
|
|
|
Linked Server Security Trouble
Tue, 1 Apr 2008 15:37:00 -0700
Hello,
I am having trouble configuring a linked server on a Windows domain that
does not have Active Directory. I would like to be able to use Windows
Authentication for this Linked Server. We are building an app that needs to
run from SERVER1 and acquire data from SERVER2 to solve some business
problem ...
|
Little database user account script need help...
Fri, 28 Mar 2008 13:31:55 -0400
Hi there, I found this script on Microsoft's site for creating a Database,
User, and Account in SQL 2005, it works really well and I like it alot, does
anyone know how I can modify it to allow that user to view/edit their
database via the Microsoft SQL Server Management Studio?
I tried adding this:
set @ ...
|
Creating new user default to DB_owner role
Thu, 27 Mar 2008 06:27:01 -0700
When I create a new SQL login via SSMS the user gets assigned db_owner role
by default. This only happens on the one database.
Removing the db_owner role during creation of the user causes SSMS to fail
with an error because it tries to remove the user that is being created from
the db_owner role.
Any s ...
|
