Hi, we have changed the port number of SQL Server 2005 to 1435. Connections to SQL server are fine and people work, but when we try to run SQL Server...
Hi there We are going to have a Netapp storage that will server all our databases, while each database is a client host database. The storage...
Thanks guys. Will check it out.
Thanks guys. tempdb is not really big. log and data are partially separated, i.e. one file group (8GB) is on the log's disk. I have heard that a...
Hi there It is obvious that putting multiple database files on different physical disk is better for performance, but what about splitting the...
Hi All, I have a .NET 2005 application that uses SSIS programming class library to load and execute SSIS package stored in SQL Server 2005 (in...
Thanks ghemant. I will ensure that. Aviel Iluz Business Intelligence Architect DP Technology www.dptech.com.au
Just to answer yout reply, ghemant. Yes, pinging is works from both. and TCP/IP is enables. The successful connection to the default instance is...
I found the problem in one of the Microsoft articles. It is all about the Firewall configuration in XP SP2. It blocks TCP/IP connection for SQL...
using ipaddressinstancename,portnumber does not work. It seems that ther is no attempt to use TCP/IP at all, which is very strange. Aviel Iluz...
I don't think MDAC is an issue, Client machines are XP sp1 or Windows 2003 server which both have at least MDSC 2.6. The port for the default...
Thanks all, I cannot connect to the server using the IP address as specified. Actualy not even to the default instace which I am able to connect...
Hi, I am struggling connection to a named instance of SQL 2000 (SP4) from another machine but without any success. I get an error message saying...
What about using stored procedure? You can use a cursor in that loop on the existing distinct values of the tranID and populate a temporary table...
The temp table was just to put the data in a table that the query can run on some data. instead you can run it on your original table. The solution...
Satya, I cheked it as follows: 1. deleteing the assigned account by xp_sqlagent_proxy_account 'DEL' 2. Assigning the account by...
Thanks Satya. The problem is that the proxy account IS assigned, although not by using xp_sqlagent_proxy_account but by using the GUI in SQL Server...
It should work also in QA. Make sure you select all the query text. I tested that in QA. Any way, you are fine now. Cheers. Aviel Iluz Database...
Which version of SQL Server are you working with? Aviel Iluz Database Administrator Pacific Micromarketing Melbourne Australia www.pacmicro.com.au
Separate names with a comma.
