|
|
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 Recommended Port Posted by S Shulman at 6/28/2004 7:29:21 PM Hi
My SQL server is lisening on port 1433 for security reasnd I would like to
change to another port can anyone recommed another specific port or it
desn't matter.
Thanks in advance,
Shmuel
...more >>
Problem Creating Login ID Posted by SqlJunkies User at 6/28/2004 5:55:17 PM I restored a database called 'MyDatabase' from a backup file. It created a user for me with the same name but no login with the same name. When I tried to create a login id with the same name (MyDataBase), it does not let me the same login id have privileges to access that database. I tried to do th...more >>
Can't use system DSN to log user on Posted by Art Billings at 6/28/2004 5:00:31 PM HI,
I have attempted to connect a user to a SQL 2000 server, running on a
Windows 2000 server using Windows Authentication and always get the
follwoing error message:
Connection failed
SQLstate:'28000'
sql server error: 18456
[microsoft][odbc sql server driver][sql server] login
failed fo...more >>
Parameterized queries running slower than non-parameterized queries Posted by bogachkov NO[at]SPAM hotmail.com at 6/25/2004 3:42:32 PM Hello
When I use a PreparedStatement (in jdbc) with the following query:
SELECT store_groups_id
FROM store_groups
WHERE store_groups_id IS NOT NULL
AND type = ?
ORDER BY group_name
It takes a significantly longer time to run (the time it takes for
executeQuery() to return ) than ...more >>
ConnectionTimeout Posted by Vlad at 6/25/2004 2:13:24 PM I'm creating connection object to SQL Server db this way
Set objConn = New ADODB.Connection
objConn.CursorLocation = adUseClient
objConn.ConnectionString =
"PROVIDER=MSDASQL;dsn=Coordinator;uid=vladc;pwd=developer4444;database=SRS;"
objConn.ConnectionTimeout = 1
objConn...more >>
web -> isa -> sql Posted by mdh333 at 6/25/2004 12:22:01 PM Sorry if this question is a little high-level, I'm the DBA and don't really know too much about ISA.
We have a web server in our DMZ that wants to connect through an ISA server to a SQL Server. There is a rule setup on the ISA server that allows connectivity on port 1433 (sql) which will point t...more >>
Remote Stored Procedures Posted by Remote server at 6/24/2004 1:26:08 PM I have a stored proc on a server called lax-dd and the
stored proc name is test. Both servers are in the same
domain and the sa passwords are the same on both servers.
I in query analyzer run exec lax-dd.dbname.dbo.test.
I get errors it doesn't understand the dash(-) in the
servername. ...more >>
log into one sql server from another server Posted by ngan at 6/24/2004 11:22:49 AM I have two servers that have IIS and SQL 2000. the first
one is where I have my webpages. The second one is where
I have my sql tables. The second server's IIS has
anonymous login unchecked (same with the first server). I
want to use the person's windows login for authentication.
In th...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Login failed for user '(null)' Posted by haltenberg NO[at]SPAM yahoo.com at 6/24/2004 3:21:48 AM I am running a third-party web application (mainly ASP and specific
pages with their own extension that are processed by a third-party
ISAPI dll) on a Windows 2000 Server (IIS 5.0) which is also a domain
controller and has MS SQL 2000 installed. Anonymous access in IIS for
this application is se...more >>
Unable to browse for available SQL servers across subnets?? Posted by dude at 6/23/2004 11:32:59 AM I have our DBA complaining that I have changed something on the network. He
can only browse for available SQL servers in the subnet where Enterprise
Manager is installed. I verified that this is indeed the case. He has a
need to use a SQL database monitoring software to monitor SQL servers tha...more >>
When will port 445 be used by SQL Server? Posted by Peter at 6/23/2004 10:57:01 AM I'm using Port Reporter to check what ports are being used between client machine and SQL Server machine. I cannot find any entry using port 445 except an entry related the loopback address 127.0.0.1. But I see port 139 being used between client machine and SQL Server machine....more >>
Body type not supported by Remote Host issue Posted by Roy Chastain at 6/23/2004 8:04:37 AM I have recently setup a 2003 server with ISA firewall and an inbound SMTP relay to provide message filtering etc and SMTP command
scanning (such as it may be). This server relays to my internal SMTP server which is an Exchange 5.5. Prior to this my Exchange
server received the email directly fro...more >>
command window open when SQL agent start Posted by (mathieu_corriveau NO[at]SPAM hotmail.com) at 6/23/2004 7:51:56 AM When i start mssqlserver service, it do not start SQLAgent
It is listed in the dependancies of both
when i start the sqlAgent manually, there is a command window that opens up with nothing in it, just the cursor blinking, BUT everything runs fine, the msssqlServer and the SQLAgent are both run...more >>
Violation of UNIQUE KEY constraint Posted by Nirm at 6/22/2004 6:04:04 PM Hi Guys
I am trying to import data to a user table using DTS
Import/Export Wizard in SQL 2000 Server from MS Excel
2002, the table has 800 plus rows of data. Necessary
Identity, Seed and Increment in table design have been
set. However, data fails to import. I tried importing the
view and...more >>
SQLBrowseConnect returns network servers during local scan Posted by Shane at 6/22/2004 5:39:01 PM Please help, deadline approaching.
I used the listsvr utility supplied from http://www.sqldev.net/misc/ListSQLSvr.htm.
And on Sql 2000 machines it works fine returning all the instances on those machines.
Yet on a particular SQL 7.0 machine, it returns a network sql 2000 server, and also a '(...more >>
SQLBrowseConnect returns network servers during local scan Posted by Shane at 6/22/2004 5:38:01 PM
Please help, deadline approaching.
I used the listsvr utility supplied from http://www.sqldev.net/misc/ListSQLSvr.htm.
And on Sql 2000 machines it works fine returning all the instances on those machines.
Yet on a particular SQL 7.0 machine, it returns a network sql 2000 server, and also a ...more >>
Windbver.exe? Posted by Sumner Paine at 6/22/2004 4:10:43 PM I have a Windows Server 2003 terminal server with a client installed to
connect to a SQL 6.5 database. I'm supposed to run windbver.exe to specify
the name, IP address, etc. of the SQL server that holds the database. This
information is only being stored per user and not globally... Does anyone
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |