|
SQL Server login with hostname masking
Is there a way in SQL Server to allow logins such as 'user@hostname.com' ala
MySQL?
...
Fri, 14 Jan 2005 12:54:12 -0600
|
bcp error
I am getting an error that I can't open the host file when running bcp
through a tsql statement. When I set the path to a local drive on the sql
server the utility runs. However, when I set the path to a unc path that the
server and service account both have permission to then it won't run.
Any ideas on ...
Fri, 14 Jan 2005 09:43:06 -0800
|
Linked Server Problem
We have 2 SQl Servers. Server A is SQL 7, and Server B is SQL 2000. We need
to push data from server A to server B. My plan is to do this via executing
a stored procedure on the 2000 server. However, I am getting the following
error: "SQL Server does not exist, or access denied". I don't get this error
...
Fri, 14 Jan 2005 08:43:07 -0800
|
nod32 scans on sql 2000 server
Hi all,
I found from the following scan that some errors in the scan log.
----------------------------------------------------------------------------
------------
Log Details
Scanning Log
NOD32 version 1.966 (20050108) NT
Command line: /config=
Operating memory - is OK
date: 8.1.2005 time: 05:38:13 ...
Fri, 14 Jan 2005 16:05:54 -0000
|
How to restrict access to database to only IUSR_
Hello Mark,
Thank you for taking the time to let me know the current status. If you
have any questions or concerns, don't hesitate to let me know. We are
always here to be of assistance!
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=========================== ...
Fri, 14 Jan 2005 10:10:49 GMT
|
Slow performance with windows authentication
Hello Ian,
After connecting to SQL server, both authentications should have the same
effect. Since you can connect to SQL server when logging on as Windows
user, the issue may be a performance issue instead of a connectivity
issues.
Please understand that identifying the causes of a performance issue ...
Fri, 14 Jan 2005 10:08:17 GMT
|
How to restrict access to database to only IUSR_
Hello Mark,
Thanks for your message.
What do you mean " I removed TCP/IP and Named Pipes from the SQL Server
Registration from within Enterprise Manager and rebooted the machine."? Do
you mean you have performed the following steps?
1. Right-click 'MYSERVER\SERVER' in SQL Enterprise Manager(SEM), ...
Fri, 14 Jan 2005 04:44:35 GMT
|
Hardware information
I'm looking at creating an association between a database and the hardware
that it is running on - for example by creating a license key that includes
a hash of the mac address.
Obviously clients will be able to query the database directly. What I'm
trying to do is to tie my client application to a specifi ...
Thu, 13 Jan 2005 17:40:10 -0800
|
Slow performance with windows authentication
Hello. I hope this is the right group for this question.
We are moving our sql server from Europe to North America. The speed of the
connection is about 1 Mb/s
If I try and run a query in query analyzer using windows authentication the
query (which was previosuly taking 3 secs) is taking 20 secs to run.
If I t ...
Thu, 13 Jan 2005 17:48:21 -0000
|
Microsoft DevDays 2004 - Smart Client 3 - Security session
Hi there,
Have you guys watched the Smart Client 3: Developing Secure Smart Client
Applications by a presenter called Jeff Levinson
(http://msdn.microsoft.com/events/devdays/sessions/).
I have got a really really quick question regarding the security hole he
found on the demo...
(you need to have watc ...
Thu, 13 Jan 2005 12:55:01 -0800
|
Repeated Login failed for user SA in Event Log.
At regular intervals there are failed login message for User SA, User User,
User Root in the event log. This seems to have started after Security Patches
were applied.
How do I stop these failed logins occuring?
Thanks
--
John Franks MIScT, MIAP, MCSA, MCSE, MCDBA ...
Thu, 13 Jan 2005 08:11:04 -0800
|
How to restrict access to database to only IUSR_
Hello Mark,
Based on the problem description, it seems that you'd like to let all the
application which is running internally can access SQL server successfully.
However, outside users cannot access SQL server from internet.
If this is what you want, you can remove TCP/IP and Named Pipes in the "SQL
...
Thu, 13 Jan 2005 11:51:31 GMT
|
SQLAgentCmdExec
The password for SQLAgentCmdExec get cracked by our password auditing
software. Can the password be manually set to make it stronger? If so, what
do I need to be aware of. Thank You. ...
Wed, 12 Jan 2005 17:07:03 -0800
|
Access Denied in .NET web application after applying Security Patc
I've been asked to fix a problem with a web application residing on a
client's Windows 2003 server that is now denying access to the SQL database
after windows security patches were applied to the server.
The patches that were applied are:
Security Update for Windows Server 2003 (KB885836)
Security Up ...
Wed, 12 Jan 2005 10:37:05 -0800
|
How to restrict access to database to only IUSR_
I am running IIS and SQL Server on the same Win2003 Server machine. Is there
a way to set up security such that only IUSR_ is allowed to access
the SQL Server 2000, even if outsiders have the connection string to the
database?
Thanks for any assistance!
...
Wed, 12 Jan 2005 10:15:01 -0800
|