all groups > sql server connect > june 2005 > threads for june 22 - 28, 2005
Filter by week: 1 2 3 4 5
Acess Denied SQL Server doesnot Exist
Posted by Shiv at 6/28/2005 4:43:03 PM
Hi I recently installed a copy of SQL Server 2000 and was unable to connect
as my SQL server gives me the message "Acess Denied SQL Server doesnot
Exist". I did use all the trouble shooting help but couldnot rectify it. The
probelm seems to be with my logon. I am starting it with a single user... more >>
SQL Port Restriction
Posted by Wade Rocco at 6/28/2005 9:08:51 AM
Hello All,
Which ports are necessary for SQL communication?? I have a test environment
with a web server and a separate db server and I want to shut down any
unnecessary ports on the web/SQL server.
Any advice is appreciated.
Thanks!!
Wade
... more >>
how to determine the best timeout value
Posted by jalie at 6/28/2005 4:36:02 AM
Hi,
I am trying to insert 75000+ records into a table via a stored procedure
(the table is empty) - the information for all those records is contained in
an xml document that is passed to the stored procedure in a string. I am
using openxml to read the xml data and to insert the records int... more >>
Exchange Linked Server
Posted by Mike at 6/27/2005 12:00:00 AM
I'm trying to run a view that calls a table in a linked server (linked to
Exchange on an SBS 03 box)
The linked server shows the correct tables in the Exchange public folders.
The query is;
CREATE VIEW dbo.vw_Exchange_Contacts
AS
SELECT CONVERT(nvarchar(50), [DAV:id]) AS DAVUID, CONVE... more >>
Unable to connect to SQL Server Personal Edition
Posted by guian NO[at]SPAM att.net at 6/26/2005 1:42:18 PM
I'm trying to connect to a local SQL Server 2000 'Personal Edition'
running on Windows XP Professional. I've tried everything, and
searched the forums for similar problems, but I can't get the
connection to work... :(
Using jdbc, with the follwing URL
jdbc:microsoft:sqlserver://localhost:14... more >>
Weird SQL behaviour
Posted by bthouin at 6/23/2005 11:54:46 PM
Hi guys,
I have a simple problem, and on the paper I've solved it, but the
results are absolutely baffling and inconsistent, hence my cry for help.
My client has an SQLServer database (designed and fed by my software) at
a hoster, with, for the sake of this exercise, 2 related tables, lets... more >>
Can no longer get dataset fill method to work after directory copy
Posted by HermanW at 6/23/2005 9:31:01 AM
I have been creating a small winforms app using VS 2005 and SQL Express. I
create serveral tables in the database and added it as the datasource for the
project. I created several forms, created several datagrids and regular
design views. After I got several of the forms running, I decided to... more >>
Lost connection to sql server
Posted by JT at 6/22/2005 10:27:02 PM
Hi,
I just installed a virtual sql server 2000 sp3a named instance on a MSCS
cluster. I was trying to get the log files onto a separate LUN in my SAN. I
changed the startup parameters in Enterprise manager to point to a new
location for the -l parameter (log) and removed the previous -l par... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Doubt about connections to sql server.
Posted by MariaGuzman at 6/22/2005 2:39:43 PM
Hi, i have some applications that use a sql server user to connect to
databases. Sometimes i Check the las batch time in enterprise manager to
see if the connection is active, and the date is expressed like this:
"01/01/1900 12:00 am"
Do somebody know why this happen??
Thanks a lot for your... more >>
SPIDs and processes
Posted by Jim at 6/22/2005 11:33:07 AM
Hello, I don't know much about SQL Server processes/SPIDs but everytime our
web app creates a ADO.NET connection and closes it, the SPID is still hanging
around in "sleeping status" well after it's closed in the ADO.NET code.
Is this normal or I am making database calls inefficiently?
I al... more >>
Unable to connect to sqlserver 2000 with SP4
Posted by ourspt at 6/22/2005 12:25:03 AM
Hi All,
I am having my SQL Server 2000 with SP3 service pack on an Windows O/S 2003
server without any service pack. My client application was able to connect
without any problems.
Now recently I have upgraded my SQL Server 2000 with SP4 Service pack and
also upgraded my Windows O/S 200... more >>
How to connect to a dedicated m/c
Posted by Lara at 6/22/2005 12:00:00 AM
Hi,
Recently i installed SQL server 2000(EE)on my remote dedicated server( win
2003). I haven't installed ant Service packs. Now the problem is i am not
able to connect to the SQL server either thru Query Analyzer or thru the
application. I have disabled the firewall, still no use. Can anyone he... more >>
|