|
|
|
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 August 2008 |
Filter by week: 1 2 3 4 5 Ports to open in Windows Firewall for SQL Server 2005 Posted by michael at 1/28/2006 7:32:26 AM I'm running the Develpers version of SQL Server 2005 on my developer machine.
I want to test an application from another machine but can neither log on nor
use the SQL Server Management Studio from the remote machine unless I turn
off the Windows Firewall on the development machine. (I made su...more >>
Problems using SMO to impersonate SQL connection (SQL2k Dev SP4 + .NET 2.0) Posted by Daniel Portal at 1/27/2006 4:11:27 PM Hi there,
Im trying to use SMO to impersonate a typed (not logged) user, using
Windows Auth to connect SQL Server!
Even though, I'm having many problems while trying to trace the
exception I got!
If you manage to perform a Windows Auth connection to SQL Server using an
inputte...more >>
Connection Failure to SQL Server 2005 Posted by Allen at 1/27/2006 11:12:26 AM I am trying to connect to a SQL Server 2005 instance from another machine
using Query Analyzer (SQL Server 2000 version) and I am getting the following
error:
Server: Msg 11, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error.
I can connect to other SQL S...more >>
load postscript file into sql Posted by Jack at 1/26/2006 11:31:02 PM We are having a website that generates postscript files when an order is
placed on it. These files are placed in a folder on the network.
I have been told to Load the postscript files into an existing sql database
and then delete the file from the folder.
If anyone has an idea on how to l...more >>
SQL Server very slow over internet... Posted by hurricane_number_one NO[at]SPAM yahoo.com at 1/26/2006 2:45:53 PM I have an application that uses SQL Server and can be run on mutiple
computers over a local area network. One of my clients has requested
to have SQL Server running at their main office and have each client
machine at a different location connecting to SQL Server over the
internet. I have been...more >>
SQL 2005 versions and Link DB2 Posted by Todd Heiks at 1/26/2006 9:43:54 AM I am trying to move our SQL 7 to standard SQL 2005 (64 bit) on a dual
processor 64 bit Server2003.
I need to link to DB2 400 data.
I installed HIS (+$5,000), but could not get it to work.
I removed HIS and upgraded to SQL 2005 (64bit) Enterprise with Microsoft
OLE DB Provider for DB2.
T...more >>
have lost the ability to get in Posted by middletree at 1/26/2006 9:38:27 AM I never, ever cross-post, but I am desparate. This was placed in the
sqlserver.server group earlier today.
I installed SQL 2005 on a new machine last week. Created a database using
scripts. Worked fine for a few days. It's not on my machine, but on a
Win2003 Vitrual Server instance which I g...more >>
Why doesn't SQL Server 2005 work on my pc? Posted by Federico Caselli at 1/26/2006 6:25:04 AM Hi,
I've installed Visual Studio 2005 pro SQL Server 2005 dev on a WMCE PC.
When I try to connect from VS to SQL I get the following error:
----------------------------------------
A connection cannot be made to the database.
Set and test the connection string.
An error has occurred w...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Remote connection to MSDE Posted by laurin1 at 1/25/2006 12:54:15 PM I'm trying to connect to the SharePoint MSDE database from Windows XP
SP2 machine over Ethernet LAN. I was getting server not found or access
denied, until I enabled TCP/IP via svrnetcn.exe. Now, I'm getting
OK
Connection failed:
SQLState: '01000'
SQL Server Error: 10061
[Microsoft][ODBC SQ...more >>
ADO connection options Posted by Tom at 1/24/2006 7:21:01 PM I noticed when connecting to SQL Server using the SQL OLEDB provider that a
number of SET commands are issued. In particular
SET CONCAT_NULL_YIELDS_NULL ON
is issued, and I'd like to change that to OFF. I've set the database option
to turn this off by default, but all of the client conn...more >>
Named instance connection problem Posted by Peter Lecki at 1/24/2006 5:46:19 PM Have an MSDE named instance which works just fine. Just installed
another instance of the same and can only connect to it using OSQL
locally, nothing across the network. I made sure to use all the
gotcha flags during install to enable network access, etc:
setup.exe DISABLENETWORKPROTOCOLS=0 ...more >>
Connect to SQL Server 2005 Posted by vul at 1/24/2006 9:55:48 AM Is it possible to register remote SQL Server 2005 in SQL Server 2000
Enterprise Manager?
Thank you
Al
...more >>
SQL Server 2005 connection string problem Posted by njaminder NO[at]SPAM hotmail.com at 1/24/2006 9:41:55 AM In my connection string when using Data Source=ServerName I can get a
connection to SQL Server.
However, I can't connect using (local),(localhost),local or localhost.
Is there any reason why this would work for SQL Server 2000 and not for
2005? Are there specific configuration setting I need t...more >>
SQL Server named instance problem with Windows Server 2003 Posted by Soheil at 1/24/2006 12:00:00 AM Hi,
I have installed SQL Server 2000 on a Windows Server 2003 machine with an
instance name of "TestDB".
But I cannot connect to this instance from another machines. It doen't even
show up in the Enterprise Manager's
"Register SQL Server" window.
But if I use the default instance, it wor...more >>
Restricting access to certain applications Posted by Gaspar at 1/23/2006 8:19:00 PM Is it possible to restrict access to SQLServer only to selected applications
(the ones I develop)?. This is why I'm asking:
Suppose user "Mary" has access to certain tables for SELECT, UPDATE, INSERT,
DELETE, etc. I want Mary to delete records on tables only in certain
conditions imposed by my...more >>
SQL Native client in Windows 98 Posted by Kirsten at 1/23/2006 7:32:07 PM Does SQLServer 2005 Native client support windows 98?
Thanks
...more >>
SQL 2000 Linked Server - Error 6: SQL Server not found Posted by Swit at 1/23/2006 4:11:01 PM I am new to linked servers and basically I want to query data from several
tables on server A and then insert that data into a simple table on server B.
I am hoping to do this from within a stored procedure on Server A rather
than writing a small app.
My limited research has been telling m...more >>
Linking Excel and SQL Posted by Preacher Man at 1/23/2006 10:25:23 AM I would like to link an Excel Spreadsheet to my SQL 2K Database. Where do I
need to start?
For example. I would like to have a cell in Excel that gives me the sum of
Sales Orders in my SQL Database. I would also like for this to be able to
change according to a date field in excel that c...more >>
login failed for user error Posted by bruce lawson at 1/22/2006 10:17:50 PM Hi, I'm fairly new at SQL access from an ASPNET webform and cannot seem to
get the SqlConnection string to work properly.
I'm running VStudio, C#, IIS 5.1, MSDE sqlserver, Net 1.1 framework. The
connection code that causes the error is:
SqlConnection conn = new SqlConnection("Data Source=MYSER...more >>
Getting a permission denied - but not using that user? Posted by jonefer at 1/22/2006 10:22:02 AM In my database I created a SQL Server user - malphaTest
In my WebConfig.xml
<add key="SQLConn"
value="Data Source=HIDSCFILE002;Initial Catalog=Membership;User
ID=malphaTest;Password=12345;Trusted_Connection=False"/>
</appSettings>
The error returned when press the search button to quer...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |