all groups > sql server connect > august 2007 > threads for august 22 - 28, 2007
Filter by week: 1 2 3 4 5
Server connection to SQL/Server Express won't work
Posted by dperson at 8/28/2007 10:28:18 PM
I have SQL/Server Express set up on two machines. I turned on all the
protocols for each. I started the server browser task on each. I opened
ports 1433 and 1434 on both firewalls. I can sometimes find the servers when
I browse. I just can't logon from either. I've tried logging on as 'sa'... more >>
Cant connect through Management Studio, Can connect Visual Studio
Posted by Burdock at 8/28/2007 2:16:01 AM
Hi,
I am having a very frustrating problem trying to connect to a remote SQL
Server 2005 at my ISP. When I try to connect through Management Studio the
ISP SQL Server returns an error of 'Login failed for user xxx (18456)'.
According to the ISP they can see my connection attempt in their lo... more >>
event 17187: SQL Server is not ready to accept new client connections
Posted by Seth at 8/28/2007 12:00:00 AM
(CrossPost: microsoft.public.opsmgr.sql, =
microsoft.public.sqlserver.connect, microsoft.public.sqlserver.server)
I installed SQL Server 2005, then i reboot the server (w2k3 r2 std ed), =
then i saw the following event:
Actually i reformated my sql server because of this event, and now it's =
... more >>
My available memory is down to very little, yet my PF Usage is 8 gigabytes (about how much memory is on the box), sql server keeps having memory issue
Posted by Daniel at 8/27/2007 4:38:12 PM
My available memory is down to very little, yet my PF Usage is 8 gigabytes
(about how much memory is on the box), sql server keeps having memory issues
yet the sqlservr.exe is using hardly any memory.. how to fix this? is there
some way to limit how much memory can be used by this PF Usage? wh... more >>
in sql server is it possible to get the amount of memory used by a stored procedure? e.g. memory usage statistics per stored procedure?
Posted by Daniel at 8/27/2007 4:26:13 PM
in sql server is it possible to get the amount of memory used by a stored
procedure? e.g. memory usage statistics per stored procedure?
... more >>
Export the Data of a field of 5000 characters length
Posted by Muhammad Kashif Azeem at 8/24/2007 12:00:00 AM
Create table myTable
( Name varchar,
Description Text )
The description column contains more than 300 characters. The sql limit is
to show only 30,35 words. Is there any tool available which can export
around 5000 characters or more data of a single column.
Regards
... more >>
help in a query plzzz
Posted by Adi at 8/23/2007 3:50:33 PM
hi, i have a simple question, mit look silly question for some one..
but please look into it n let me know how to write a query for it.. i
have 3 cols
col1 col2 col3
----- ----- ------
123 null 1159
434 null 1159
555 233 1490
999 null 1440
234 667 1159
the result set should... more >>
Linked Server can't find server/instance, but SSMS does
Posted by Dan at 8/22/2007 9:52:00 PM
I am trying to create a linked server between 2 SQL Servers. The server that
I'm trying to connect to has 2 instances of SQL Server on it. One is SQL 2000
STD and is the default instance. The other is SQL 2005 Wrkgrp and has the
instance name 'sql05'. I need to be able to connect to the linked... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
HELP: SQL Server 2005 Express OLEDB Connection from VB6
Posted by thompsom NO[at]SPAM aecl.ca at 8/22/2007 7:57:12 AM
Hi.
I cannot connect to SQL Server 2005 Express on a Windows XP SP2
machine from a Windows 2000 PC using the SQLNCLI OLEDB provider in
VB6. I can create an ODBC System DSN and connect just fine, but I
cannot use a connection string with "Provider=SQLNCLI" or
"Provider=SQLNCLI.1". I always g... more >>
|