I recently had configured my Web Server based on Windows 2003 Server and IIS 5x. I'd also installed SQL Server 2005 into this. Now I want toc onfigure this SQL Server, so that my client can access their database through a DNS name. I request you all for your kind support in this regard. Thanks in advance.
View 5 RepliesI recently have configured my Web Server based on Windows 2003 Server and IIS 5x. I'd also installed SQL Server 2005 into this. Now I want toc onfigure this SQL Server, so that my client can access their database through a DNS name. I request you all for your kind support in this regard. Thanks in advance.
View 1 Replies View RelatedI have recently configured a Web Server based on Windows 2003 Server and IIS 5x. I'd also installed SQL Server 2005 into this. Now I want toc onfigure this SQL Server, so that my client can access their database through a DNS name. I request you all for your kind support in this regard. Thanks in advance.
View 1 Replies View Relatedhi there!
i have been trin to configure my network for the sql server 6.5 but in vain.Actually
i have two pc in the network , one is server and the other is workstation.i install
SQL server on the NT server and then install the sql client oon the workstation but i
donno how to configure that client for the server.
so i just want u leet me that what particular steps should i follow to make that
network work properly for the sql server 6.5. i just wanna use sql server 6.5 in a
simple situation. i am not an advance user of the sql server 6.5.
i will be greatful to GOD if uu help in this problem.
sincerely,
romanafroz@hotmail.com
Hi,
I have installed MS SQL Server on a win XP and a MS SQL Server client on a win2000. I don’t know how to configure this client to access the server remotely.
Any pointer?
Thanks.
I am very new to SQL Server.
I have searched and could not find an answer for this one I read log and it said
Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql server};server=KENSHIN;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
driver={sql server};server=KENSHIN;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
driver={sql server};server=KENSHIN;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
SQL Server configuration failed.
how do I fix this?
Hi,
I've a SQL Server 2000 (SP4) installed on Windows 2000 Server.
The system has 4GB RAM.
SQL Server not using more than 2GB RAM even I set the following.
AWE enabled.
Max server Memory (MB) : 3GB
SQLService account is enabled for "Lock Pages in Memory"
Can you please help what I'm missing here?
Thanks in advance.
Regards,
Mkarumuru
Our company is going to use SAN (HP or EMC or Fuji) for SQL Server failover rather than MSCS. So far, DBA has no knowledge of SAN.
Would you please to tell me, how does SAN depend on SQL Server? I assume SAN software can make disk failover if there is a network, disk or OS failure in primary node. If SQL Server or SQL Agent is failure, can SAN software detect it? (or can SAN disk failover depend on SQL Server or SQL Agent services?)
Please let me know where can I find any configuration document regarding SAN for SQL Server failure. I had spent 2 days in HP and EMC wrbsite and found nothing.
Happy Thanksgiving.
Mary
Hi all,
Please, tell me how to configure database SQL server 2000 for a large system, and make it uninterrupted run.
Thanks
We just got a new server. We are running Windows 2000 with Office 2000 and SQL Server 2000 (Standard Edition).
To set up the mail for SQL 2000 it says to use Outlook client in "corporate" mode. This mode doesn't have the IMAP option on internet Mail only POP3.
Did I miss an option while installing Outlook?
I've only been able to find a third party vendor that has a solution but our IS/IT people are not in favour of going this route.
Any thoughts on how to get around this?
Thanks for your time.
Hi,
Pls let me know if SQL Server 2005 Management Studio (client tools only) is compatible with Windows Server 2000 or not?
Thanks in advance.
Regards,
Bhuvana
Hi,
A quick Q for all the Sql Server 2000 beta testers out there. Does anyone know of any problems associated with using SS2000 Enterprise Manager with a SS7 backend running SP2? In particular, I'm keen to try out the Tsql debugger features, if they'll work with SS7.
Many thanks in advance,
Jon Reade,
Sql Server 7 DBA
NEC Technologies (UK) Ltd
Telford, Shropshire.
The SQL Enterprise Manager and SQL Agent will not see the local SQL server install. SQL Agent won't start. It looks like one of our server guys installed something that messed up the SQL client components.
Remote clients can connect fine.
I wan to re-install the client. Where sould I get the install. I have SQL Server Service Pack 3a installed on the server. I only want to install the client portion but I want the latest for SQL 2000.
Thanks,
Chris
I have a SQL 7 Enterprise Edition production server.
I have installed SQL 2000 personal edition on a client station.
I wish to use the 2000 tools to view,modify and create objects on the SQL 7 production server. These include stored procs,tables,dts packages etc.
What are the potential pitfalls of this. I am using this strategy to introduce myself to the SQL 2000 enviroment, and perhaps utilise some of its benefits.
Has anyone tried this type of set up.
According to MS Knowledge Base Article 269824, "[SQL Server 2000 ClientTools] ... must be installed ... on any computer on which someone may makedesign changes in an Access project to a SQL Server 2000 database".This is the situation I'm facing. Can I download these Client Tools andinstall them for free, or are they only available on the SQL Server 2000Installation CD?Thanks for any help!
View 1 Replies View Related
Hi
I have SQL Server2005 client in my system,I am able to connect SQL Server 2000,but I am unable to create DTS packages.2005 client not at all showing Local packages icon to create package.
any body experianced with this Please guide me ragarding.
When you connect to SQL Server using SQLConnection, how to set client machine name(or IP address) so that you can monitor the process on Server side using Enterprise Manager?
View 2 Replies View RelatedI'm trying to remember how to install the SQL 2000 client tools onto a SQL 2005 server. There are a couple of bizarre steps that will allow this to happen, but I can't for the life of me remember what comes after the unicycle down the stairs with the umbrella stand of machetes.
Can anybody remember the magic, or do I resort to using VPC to kludge the install until I can find my clay tablets again?
-PatP
I'm
having difficulties when connecting to our SQL server 2000 from my SQL
Server Mgmt Studio 2005. I can't create tables and columns due to
permission errors. But from 2000 (on a different machine) it works
fine. *Sometimes* even when I log in with my AD account it won't let me
in and complains that user 'null' is not authorized to log in...
Anyway, I've installed both SP1 and SP2 and the problem still persists.
Any help is appreciated.
P.S>
I tinstalled SQL 2000 on my machine but that didn't help either; I
guess the 2005's configurations are being read by 2000.
I have recently installed SQL 2005 client tools with SQL Server Management Studio and accessing databases on a SQL 2000 server. The response I am getting is extremely slow. Should I go back to SQL 2000 client or are there methods by which I can improve the performance.
Thanks
Sam
Hi,
I have a server (WIN 2000 server), is connected with many clients mostly having Win 2000 Professional OS. My application is developed in VB 6.0 and we have MS SQL Server 2000 DB in our server. All the clients with win 2000 professional have no problem with connecting and accessing my SQL Database. But few of my WIN XP clients don€™t connect to database thru my application. It gives error as follows.
Runtime error
Login Failed for user €˜(null)€™ . Reason: Not associated with a trusted SQL Connection.
Can anyone help me?
Regards
Ahmed Sahib
I have a 500-MB full installation CD for SQL Server 2000. All I needis to install "Client Connectivity" component (about 272K) on a bunchof workstations for users across the nation.How do I reduce the installation file size, by eliminating most of theunwanted files?Thanks.
View 2 Replies View RelatedHi ;
I am trying to create several Excel sheets using SQL 2000 views like so:
Select * INTO [Excel 8.0;Database="C:spreadSheetsaNew.xls"] FROM [aView].
When I try and execute this in my app I get the following - Specified owner
name 'Excel 8.0;Database=c:spreadSheetsaNew.xls' either does not exist or
you do not have permission to use it.
If I use the above Select statement with an OLEDB connection it works.
I am using Imports System.Data.SqlClient, instantiating a new SQlConnection
object, opening the connection, etc..
Thanks,
Gordon
cant connect to sql server 2000 from c# 2003
View 1 Replies View Related
dear all,
in order to install a program i need to connect through SQL 2000 client to SQLserver2005.
it is possible?
Hi,
I am a SQL DBA involved in accomplishing various activities using Enterprise Manager by regestering servers of various countries.
Now as the NT Team has gone for auditing implementation in all the servers in OS lever, they find Access violations from the workstation from where I connect to the server. This does not happens if I unregester the Servers from Enterprise manager and use only query analyzer.
Note: We have our own users in OS as wel as in SQL SERVER .
Its Urgent!!! Please help!!!
Hi,
I'm trying to re-install SQL Server 2000 Desktop Engine andSQL Server client tools. I have succesfully re-installed the desktop engine,but I am getting the following error message when attempting to re-install theclient tools.
"Setup has detected an existing client tools only installation.
Please use the maintenance mode to add client components"
Unfortunately the Upgrade/Add/Remove option is greyed out as
an install option.
I attempted the registry hive rebuild option and the install appeared
to succeed. However, I cannot access any tools (Enterprise Manager
comes up with the message "The selected file cannot be found").
At this point, the desktop engine appears in Add/Remove programs
Window, but no other SQL Server components.
Any help very much appreciated!
Eric Yeoman.
Hi,I've developed an ASP.NET application which uses MS-SQL Server 2000 as abackend. But as the site hits increase SQL server reponse becomes lower.At some stage after that SQL Server gets automativally stopped bringingcomplete web-application down to halt. i checked the Windows 2000 EventLogs and found several error logs indicating folloowing line."SQL Server 2000 Error 17805 Invalid buffer received from client.". Butno errors on UI side. What may be the actual problem.In storedproceduresor at some other place?Awaiting favourble reply.Regards,Amit*** Sent via Developersdex http://www.developersdex.com ***
View 1 Replies View RelatedI think I may have figured out the solution to my recent conundrum with SQL Server 2000 that had me stressed and depressed over the last couple of days. In a nutshell, after a HotFix was installed on a SQL2K database server I have space on, I was unable to perform INSERT or UPDATE queries on database table of type TEXT, when trying to either create or modify records with more than 4,000 characters of data. While it was frustrating as heck, it seemed too rigid to be random, so I did some snooping.
The HotFix was intended to solve a known problem of not being able to run UPDATEs against TEXT fields, but in so doing, caused another headache entirely: http://support.microsoft.com/?kbid=839523
Apparently this is a semi-known problem, in that a certain HotFix forces SQL Server 2000 to be a lot more stringent in requiring explicit declaration of data types and data lengths for parameters in stored procedure. In my client code, I was initially using the overloaded constructor of the SqlParameter object that took as arguments only the parameter name and a value, without specifying a value from the SQLDBType enumeration or length of the parameter (which in my case, needs to be TEXT and 16 (or 2147483647), respectively):
System.Data.SqlDataAdapter.InsertCommand.Parameters.Add(new SqlParameter("@parameterName",parameterValue);
It appears that after the HotFix is installed, if the client doesn’t syntactically set the type and length of data for a parameter, SQL Server and/or .NET will default to a type of NVARCHAR, which has the 4,000-character limit. This all makes sense. I’m going to now need to modify the code to straight out declare what’s going in the SPROC:
System.Data.SqlDataAdapter.InsertCommand.Parameters.Add(new SqlParameter("@parameterName",SqlDbType.Text);
System.Data.SqlDataAdapter.InsertCommand.Parameters["@parameterName"].Value = parameterValue;
It’s a minor change, and it sucks that I have to make it after the code had worked flawlessly over several thousands executions over several months, but c’est la vie! Better thay than have to rebuild my DB from scratch or switch to a new server. Changing the client code evidently is the only known fix at this time: http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b827366
Dear all,
we have tables with many image columns. We fill these image columns via ODBC and SQLPutData as described in MSDN etc (using SQL_LEN_DATA_AT_EXEC(...), calling SQLParamData and sending the data in chunks of 4096 bytes when receiving SQL_NEED_DATA).
The SQLPutData call fails under the following conditions with sqlstate 08S01
- The database resides on SQL Server 2000
- The driver is SQL Native Client
- The table consists e.g. of one Identity column (key column) and nine image columns
- The data to be inserted are nine blocks of data with the following byte size:
1: 6781262
2: 119454
3: 269
4: 7611
5: 120054
6: 269
7: 8172
8: 120054
9: 269
The content of the data does not matter, (it happens also if only zero bytes are written), nor does the data origin (file or memory).
All data blocks including no 7 are inserted. If the first chunk of data block 8 should be written with SQLPutData the function fails and the connection is broken. There are errors such as "broken pipe" or "I/O error" depending on the used network protocol.
If data no 7 consists of 8173 bytes instead of 8172 all works again.
(Changing the 4096 chunk size length does not help)
Has anybody encountered this or a similar phenomenon?
Thank you
Eartha
On Windows XP systems I get the following issue when trying to browse the MSDB folder in SSIS
Client unable to establish connection
Encryption not supported on SQL Server. (Microsoft SQL Native Client)
I have noticed another post where several others have noticed the same issue. It appears to only occur on Windows XP installations. Is there a workaround or fix for this?
I installed Micrsoft Server Desktop Engine from the CD I received in
my ASP.net book. The installation went fine and then I went to the DOS
prompt and did the "setup SAPWD..." and it ran. I restarted my computer and
opened ASP Matrix and went to the Data tab and proceed to connect to
the server. It gave me an error message it couldn't connect.
So I
uninstalled MSDE and made sure the sql2ksp3 folder was gone. So I went
ahead and installed the MSDE again from the CD again and then went to
DOS
to do the setup. It ran through the setup until the very end with 11
seconds remaining and received error message " Setup failed to
configure the server. Refer to the server error logs and setup logs for
more information. I have tried it several times and it always
stops around 11 seconds. I have tried to install the download from
microsoft.com
instead the CD and that didn't work also. So at this point I
am stuck. PLEASE HELP!
I also checked my Registry keys for a file called PendingFileRenameOperations and it wasn't in the registry keys.
If anyone has any suggestions I would appreciate it.
I'm having a world of trouble with the Reporting Services Server. The install went fine. I went in to configure the Report Server and when creating the Report Server and the Report Manager virtual directories I get the following error: "The virtual directory could not be created. The previously set virtual directory will still be used." The problem with this is that I have not previously set a virtual directory. When clicking on the link I get the additional error information: "System.IO.FileNotFoundException:
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at System.Management.ManagementObject.InvokeMethod(String methodName, ManagementBaseObject inParameters, InvokeMethodOptions options)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.CreateVirtualDirectory(String virtualDirectory, String path)"
When I check IIS the directories were created but the Reporting Services Configuration Manager does not see them unless I attempt to recreate them again without deleting them from IIS.
Anyone have any ideas as to this disconnect?
Thanks in advance!