Connect to Remote SQL SERVER Express 2005 server

I am trying to connect to a remote SQL Express server (using query analyzer)
and I am not able to. If I run SQL Server Managemant Studio I can connect
(using Windows Authentication). I have tried using the IP address of the
server and just the server name but no luck. There is only one instance
running on the server (default). This server is on a different subnet. The
error I receive is: Server: Msg 14, Level 16, State1
[microsoft][ODBC SQL Server Driver][DBNETLIB] Invalid Connection
Any ideas?
TimAre you sure the SQL Express instance is the default? It normally installs
as a named instance SQLEXPRESS.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Tim Kelley" <tkelley@.company.com> wrote in message
news:%23jgSL5QzGHA.4104@.TK2MSFTNGP02.phx.gbl...
>I am trying to connect to a remote SQL Express server (using query
>analyzer) and I am not able to. If I run SQL Server Managemant Studio I
>can connect (using Windows Authentication). I have tried using the IP
>address of the server and just the server name but no luck. There is only
>one instance running on the server (default). This server is on a
>different subnet. The error I receive is: Server: Msg 14, Level 16, State1
> [microsoft][ODBC SQL Server Driver][DBNETLIB] Invalid Connection
> Any ideas?
> Tim
>|||You are right. When I try connecting using servername/sqlexpress I get the
following error:
[DBNETLIB][ConnectionOpen(Connect)).]SQL Server does not exist or Access
Denied.
Thanks,
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:O9BqpTRzGHA.1292@.TK2MSFTNGP03.phx.gbl...
> Are you sure the SQL Express instance is the default? It normally
> installs as a named instance SQLEXPRESS.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Tim Kelley" <tkelley@.company.com> wrote in message
> news:%23jgSL5QzGHA.4104@.TK2MSFTNGP02.phx.gbl...
>>I am trying to connect to a remote SQL Express server (using query
>>analyzer) and I am not able to. If I run SQL Server Managemant Studio I
>>can connect (using Windows Authentication). I have tried using the IP
>>address of the server and just the server name but no luck. There is only
>>one instance running on the server (default). This server is on a
>>different subnet. The error I receive is: Server: Msg 14, Level 16, State1
>> [microsoft][ODBC SQL Server Driver][DBNETLIB] Invalid Connection
>> Any ideas?
>> Tim
>|||How about servername\sqlexpress ? Is the SQLBrowser enabled and running on
the SQL Express server?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Tim Kelley" <tkelley@.company.com> wrote in message
news:O5ps1hRzGHA.996@.TK2MSFTNGP03.phx.gbl...
> You are right. When I try connecting using servername/sqlexpress I get
> the following error:
> [DBNETLIB][ConnectionOpen(Connect)).]SQL Server does not exist or Access
> Denied.
> Thanks,
>
> "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
> news:O9BqpTRzGHA.1292@.TK2MSFTNGP03.phx.gbl...
>> Are you sure the SQL Express instance is the default? It normally
>> installs as a named instance SQLEXPRESS.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> Use of included script samples are subject to the terms specified at
>> http://www.microsoft.com/info/cpyright.htm
>> "Tim Kelley" <tkelley@.company.com> wrote in message
>> news:%23jgSL5QzGHA.4104@.TK2MSFTNGP02.phx.gbl...
>>I am trying to connect to a remote SQL Express server (using query
>>analyzer) and I am not able to. If I run SQL Server Managemant Studio I
>>can connect (using Windows Authentication). I have tried using the IP
>>address of the server and just the server name but no luck. There is only
>>one instance running on the server (default). This server is on a
>>different subnet. The error I receive is: Server: Msg 14, Level 16,
>>State1
>> [microsoft][ODBC SQL Server Driver][DBNETLIB] Invalid Connection
>> Any ideas?
>> Tim
>>
>|||Got the same error. I found a registry entry that fixed the problem.
HKLM\Software\Microsoft\MSSQLServer\Client\ConnectTo.
Added REG_SZ key <servername> with data set to:
<servername>,DBMSSOCN,<servername>,1433
Don't know what this does, but I am able to connect now.
Thanks,
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:uP3wAxRzGHA.2036@.TK2MSFTNGP05.phx.gbl...
> How about servername\sqlexpress ? Is the SQLBrowser enabled and running
> on the SQL Express server?
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Tim Kelley" <tkelley@.company.com> wrote in message
> news:O5ps1hRzGHA.996@.TK2MSFTNGP03.phx.gbl...
>> You are right. When I try connecting using servername/sqlexpress I get
>> the following error:
>> [DBNETLIB][ConnectionOpen(Connect)).]SQL Server does not exist or Access
>> Denied.
>> Thanks,
>>
>> "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
>> news:O9BqpTRzGHA.1292@.TK2MSFTNGP03.phx.gbl...
>> Are you sure the SQL Express instance is the default? It normally
>> installs as a named instance SQLEXPRESS.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> Use of included script samples are subject to the terms specified at
>> http://www.microsoft.com/info/cpyright.htm
>> "Tim Kelley" <tkelley@.company.com> wrote in message
>> news:%23jgSL5QzGHA.4104@.TK2MSFTNGP02.phx.gbl...
>>I am trying to connect to a remote SQL Express server (using query
>>analyzer) and I am not able to. If I run SQL Server Managemant Studio I
>>can connect (using Windows Authentication). I have tried using the IP
>>address of the server and just the server name but no luck. There is
>>only one instance running on the server (default). This server is on a
>>different subnet. The error I receive is: Server: Msg 14, Level 16,
>>State1
>> [microsoft][ODBC SQL Server Driver][DBNETLIB] Invalid Connection
>> Any ideas?
>> Tim
>>
>>
>

Connect to Remote SQL SERVER Express 2005 server

I am trying to connect to a remote SQL Express server (using query analyzer)
and I am not able to. If I run SQL Server Managemant Studio I can connect
(using Windows Authentication). I have tried using the IP address of the
server and just the server name but no luck. There is only one instance
running on the server (default). This server is on a different subnet. The
error I receive is: Server: Msg 14, Level 16, State1
[microsoft][ODBC SQL Server Driver][DBNETLIB] Invalid Connection
Any ideas?
TimAre you sure the SQL Express instance is the default? It normally installs
as a named instance SQLEXPRESS.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Tim Kelley" <tkelley@.company.com> wrote in message
news:%23jgSL5QzGHA.4104@.TK2MSFTNGP02.phx.gbl...
>I am trying to connect to a remote SQL Express server (using query
>analyzer) and I am not able to. If I run SQL Server Managemant Studio I
>can connect (using Windows Authentication). I have tried using the IP
>address of the server and just the server name but no luck. There is only
>one instance running on the server (default). This server is on a
>different subnet. The error I receive is: Server: Msg 14, Level 16, State1
> [microsoft][ODBC SQL Server Driver][DBNETLIB] Invalid Connecti
on
> Any ideas?
> Tim
>|||You are right. When I try connecting using servername/sqlexpress I get the
following error:
[DBNETLIB][ConnectionOpen(Connect)).]SQL Server does not exist or Ac
cess
Denied.
Thanks,
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:O9BqpTRzGHA.1292@.TK2MSFTNGP03.phx.gbl...
> Are you sure the SQL Express instance is the default? It normally
> installs as a named instance SQLEXPRESS.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Tim Kelley" <tkelley@.company.com> wrote in message
> news:%23jgSL5QzGHA.4104@.TK2MSFTNGP02.phx.gbl...
>|||How about servername\sqlexpress ? Is the SQLBrowser enabled and running on
the SQL Express server?
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Tim Kelley" <tkelley@.company.com> wrote in message
news:O5ps1hRzGHA.996@.TK2MSFTNGP03.phx.gbl...
> You are right. When I try connecting using servername/sqlexpress I get
> the following error:
> [DBNETLIB][ConnectionOpen(Connect)).]SQL Server does not exist or
Access
> Denied.
> Thanks,
>
> "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
> news:O9BqpTRzGHA.1292@.TK2MSFTNGP03.phx.gbl...
>|||Got the same error. I found a registry entry that fixed the problem.
HKLM\Software\Microsoft\MSSQLServer\Clie
nt\ConnectTo.
Added REG_SZ key <servername> with data set to:
<servername>,DBMSSOCN,<servername>,1433
Don't know what this does, but I am able to connect now.
Thanks,
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:uP3wAxRzGHA.2036@.TK2MSFTNGP05.phx.gbl...
> How about servername\sqlexpress ? Is the SQLBrowser enabled and running
> on the SQL Express server?
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Tim Kelley" <tkelley@.company.com> wrote in message
> news:O5ps1hRzGHA.996@.TK2MSFTNGP03.phx.gbl...
>

Confusion over SP versions

Hi,
I have downloaded and run the file sql2ksp3.exe for
SQL Server 2000.
However, when I run select @.@.version in SQL Analyser it
returns the details for version 2.
ie,
Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19
2001 13:23:50
Is this OK? Has the SP deployed correctly?
regards
john
Hi,
After the SP3 upgrade the build number should be Microsoft SQL Server
2000 - 8.00.760.
You could check this in SQL 2000 using the below command in query analyzer:-
select serverproperty('ProductLevel')
Can you down load the SP3a from below site and try applying it. After the
upgrade execute the above statement
to get service pack level.
http://www.microsoft.com/sql/downloads/2000/sp3.asp
Thanks
Hari
MCDBA
"John Mullen" <anonymous@.discussions.microsoft.com> wrote in message
news:c4ea01c47a35$714a3300$a501280a@.phx.gbl...
> Hi,
> I have downloaded and run the file sql2ksp3.exe for
> SQL Server 2000.
> However, when I run select @.@.version in SQL Analyser it
> returns the details for version 2.
> ie,
> Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19
> 2001 13:23:50
> Is this OK? Has the SP deployed correctly?
> regards
> john
>
|||IIRC, if you run the sp3.exe file, it just extracts the contents into a
folder. You need to go to that folder and run setup.exe ...
http://www.aspfaq.com/
(Reverse address to reply.)
"John Mullen" <anonymous@.discussions.microsoft.com> wrote in message
news:c4ea01c47a35$714a3300$a501280a@.phx.gbl...
> Hi,
> I have downloaded and run the file sql2ksp3.exe for
> SQL Server 2000.
> However, when I run select @.@.version in SQL Analyser it
> returns the details for version 2.
> ie,
> Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19
> 2001 13:23:50
> Is this OK? Has the SP deployed correctly?
> regards
> john
>
|||Thanks Aaron,
sometimes the most obvious things are the most elusive
regards
john

>--Original Message--
>IIRC, if you run the sp3.exe file, it just extracts the
contents into a
>folder. You need to go to that folder and run
setup.exe ...
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>
>"John Mullen" <anonymous@.discussions.microsoft.com> wrote
in message[vbcol=seagreen]
>news:c4ea01c47a35$714a3300$a501280a@.phx.gbl...
19
>
>.
>

Confusion over SP versions

Hi,
I have downloaded and run the file sql2ksp3.exe for
SQL Server 2000.
However, when I run select @.@.version in SQL Analyser it
returns the details for version 2.
ie,
Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19
2001 13:23:50
Is this OK? Has the SP deployed correctly?
regards
johnOn my version its saying Microsoft SQL Server 2000 -
8.00.760 (Intel X86) Dec 17 2002 14:22:05.
So my version seems to be ahead of yours.
Peter
>--Original Message--
>Hi,
>I have downloaded and run the file sql2ksp3.exe for
>SQL Server 2000.
>However, when I run select @.@.version in SQL Analyser it
>returns the details for version 2.
>ie,
>Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov
19
>2001 13:23:50
>Is this OK? Has the SP deployed correctly?
>regards
>john
>.
>|||Hi,
After the SP3 upgrade the build number should be Microsoft SQL Server
2000 - 8.00.760.
You could check this in SQL 2000 using the below command in query analyzer:-
select serverproperty('ProductLevel')
Can you down load the SP3a from below site and try applying it. After the
upgrade execute the above statement
to get service pack level.
http://www.microsoft.com/sql/downloads/2000/sp3.asp
Thanks
Hari
MCDBA
"John Mullen" <anonymous@.discussions.microsoft.com> wrote in message
news:c4ea01c47a35$714a3300$a501280a@.phx.gbl...
> Hi,
> I have downloaded and run the file sql2ksp3.exe for
> SQL Server 2000.
> However, when I run select @.@.version in SQL Analyser it
> returns the details for version 2.
> ie,
> Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19
> 2001 13:23:50
> Is this OK? Has the SP deployed correctly?
> regards
> john
>|||IIRC, if you run the sp3.exe file, it just extracts the contents into a
folder. You need to go to that folder and run setup.exe ...
--
http://www.aspfaq.com/
(Reverse address to reply.)
"John Mullen" <anonymous@.discussions.microsoft.com> wrote in message
news:c4ea01c47a35$714a3300$a501280a@.phx.gbl...
> Hi,
> I have downloaded and run the file sql2ksp3.exe for
> SQL Server 2000.
> However, when I run select @.@.version in SQL Analyser it
> returns the details for version 2.
> ie,
> Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19
> 2001 13:23:50
> Is this OK? Has the SP deployed correctly?
> regards
> john
>|||Thanks Aaron,
sometimes the most obvious things are the most elusive
regards
john
>--Original Message--
>IIRC, if you run the sp3.exe file, it just extracts the
contents into a
>folder. You need to go to that folder and run
setup.exe ...
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>
>"John Mullen" <anonymous@.discussions.microsoft.com> wrote
in message
>news:c4ea01c47a35$714a3300$a501280a@.phx.gbl...
>> Hi,
>> I have downloaded and run the file sql2ksp3.exe for
>> SQL Server 2000.
>> However, when I run select @.@.version in SQL Analyser it
>> returns the details for version 2.
>> ie,
>> Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov
19
>> 2001 13:23:50
>> Is this OK? Has the SP deployed correctly?
>> regards
>> john
>
>.
>

Confusion over SP versions

Hi,
I have downloaded and run the file sql2ksp3.exe for
SQL Server 2000.
However, when I run select @.@.version in SQL Analyser it
returns the details for version 2.
ie,
Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19
2001 13:23:50
Is this OK? Has the SP deployed correctly?
regards
johnHi,
After the SP3 upgrade the build number should be Microsoft SQL Server
2000 - 8.00.760.
You could check this in SQL 2000 using the below command in query analyzer:-
select serverproperty('ProductLevel')
Can you down load the SP3a from below site and try applying it. After the
upgrade execute the above statement
to get service pack level.
http://www.microsoft.com/sql/downloads/2000/sp3.asp
Thanks
Hari
MCDBA
"John Mullen" <anonymous@.discussions.microsoft.com> wrote in message
news:c4ea01c47a35$714a3300$a501280a@.phx.gbl...
> Hi,
> I have downloaded and run the file sql2ksp3.exe for
> SQL Server 2000.
> However, when I run select @.@.version in SQL Analyser it
> returns the details for version 2.
> ie,
> Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19
> 2001 13:23:50
> Is this OK? Has the SP deployed correctly?
> regards
> john
>|||IIRC, if you run the sp3.exe file, it just extracts the contents into a
folder. You need to go to that folder and run setup.exe ...
http://www.aspfaq.com/
(Reverse address to reply.)
"John Mullen" <anonymous@.discussions.microsoft.com> wrote in message
news:c4ea01c47a35$714a3300$a501280a@.phx.gbl...
> Hi,
> I have downloaded and run the file sql2ksp3.exe for
> SQL Server 2000.
> However, when I run select @.@.version in SQL Analyser it
> returns the details for version 2.
> ie,
> Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19
> 2001 13:23:50
> Is this OK? Has the SP deployed correctly?
> regards
> john
>|||Thanks Aaron,
sometimes the most obvious things are the most elusive
regards
john

>--Original Message--
>IIRC, if you run the sp3.exe file, it just extracts the
contents into a
>folder. You need to go to that folder and run
setup.exe ...
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>
>"John Mullen" <anonymous@.discussions.microsoft.com> wrote
in message
>news:c4ea01c47a35$714a3300$a501280a@.phx.gbl...
19[vbcol=seagreen]
>
>.
>

Confusing layout in SSIS with regard to "Execute SQL Task".

I hope someone can help.

I'm trying to read rows from a SQL Server Table and for each row use a few columns as parameters into a query to be run against oracle which will delete oracle rows.

I add OLDEB connections for Oracle and SQL and then I try to add a "Execute SQL Task". I've also tried a "OLE Command" but I can't get the mapping of the columns to the parameters to work.

There is lots of articles on the web that talk in general around parameterized queries but no clear examples.

I also find the difference between the Control Flow and Data Flow tabs confusing as its not intuitive where to place things. It also appears to force me to re-define things that it should already know (this is no doubt because I'm interpreting what I've done / acheived wrongly).

I have my source and destination on the "Data Flow" tab along with a "Execute SQL Task" object in the middle.

I'm setting its "connection manager" the Oracle (i.e. the destination where I want the deletes to be executed). I don't follow why this also has a "connection property, surely this it set when I drag the output of the SQL Server OLEDB Source to the input of the "Execute SQL Task".

Perhaps I'm expected too much from the wizards / dialogs and I have to create "variables" and "parameters" myself?

Any help or suggestions would be very much appreciated.

Thanks in advance

Craig

Scotland

Craig,

In general, you can think in the control flow as the one responsible for the workflow of the package; it could be also use to perform batch operations against a table. In you case, for example you could issue a delete statement using an execute sql task against the Oracle table to delete all rows at once. In order to do so, you would need to have a staging table that holds the rows that need to be delete.

The DataFlow; is deemed to move data and perform operations in a row-by-row basis. You could solve your problem by using an OLE DB command transformation to perform the delete. The drawback with this approach, it is that the delete statement would be performed for every row in the dataflow pipeline; so the performance is affected considerably.

If all you want to do is to delete some rows in table A when they exist in Table B; I would suggest to stick with an execute sql task that uses both tables; so it is done i one transaction.

In order to have a 'parameterized query' you have to put the the SQL statement in a SSIS variable; set the EvaluateAsExpression=TRUE; and create an expression that gives the expected SQL statement.

I hope this helps you

|||

Thanks,

Some comments.

"If all you want to do is to delete some rows in table A when they exist in Table B; I would suggest to stick with an execute sql task that uses both tables; so it is done i one transaction."

One table exists in SQL Server, then other in Oracle, does you comment still apply?

"In order to have a 'parameterized query' you have to put the the SQL statement in a SSIS variable; set the EvaluateAsExpression=TRUE; and create an expression that gives the expected SQL statement."

MUST I do this. This does not appear to me to be in the nature of a parameterized query? Would this method still use "Prepared Statements" ?

Lastly, I'm still stuck in that my real issue is on how to map input data (from SQL) to parameters (to Oracle), I think if I followed your example, I'd still have that same problem only now I would be trying to map to a variable that was my entire query instead of just a parameter?

Thanks for the help so far and best regards

Craig

|||

Can you create and populate a staging table in the Oracle side? If so, you could load all the data in the SQL server table into a staging table in the Oracle side and then use an execute sql task to perform a 1 time update. This is the way I do this kind of things because it's more efficient performance wise.

If that is not possible; I guess you have to stick with the data flow/OLE DB command approach. But I cannot help with that as I don't have an Oracle instance to test how the parameters get mapped.

Confliction between SQL Server 2005 and SQL Server 2005 Express Edition

Hi,

My objective is using a single DB file (mdf file) + SQL Server Express 2005 to run my program

I got two softwares here, Visual Studio 2005 and SQL Server 2005. Firstly, I installed Visual Studio 2005, normally the SQL Server 2005 Express Edition will be installed with this software. After finishing the installation. I opened a new project and try to open a DB file (.mdf) from Visual Studio 2005, it works. The problem is that I can't restore the mdf file from an old database file since it lose a lot of functions that appear in SQL Server 2000 / SQL Server 2005. And it is too troublesome and inconvenient to edit a DB file in Visual Stuio 2005.

Therefore, I have to install SQL Server 2005 for me to edit the mdf file, so that I can modify, backup, or even restore the mdf file with another DB file. After the installation of SQL Server 2005, I got a tool, SQL Server Managment Studio, to edit the mdf file. I can open the mdf file but when I double-clicked on the mdf file in Visual Studio 2005, it gives me the following error message:

Connections to SQL Server files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL:http://go.microsoft.com/fwlink/?LinkId=49251

It seems the SQL Server 2005 modify some of the files in SQL Server 2005 Express Edition. Is that SQL Server 2005 and SQL Server 2005 Express Edition cannot be exist at the same time?

The issue is I'm working on my computer, but I dun want to install SQL Server 2005 in the server that I will transfer to. It will be much like using Access DB file, without the Microsoft Access software, the program can still work well. However, when I'm still in programming stage, I do hope to have a DB file as the source file for my program, but I can do some editing works with SQL Server 2005.

Does anyone can give me a suggestion? Thanks for your kindly reply.

Calvin

On my machine I have SQL2005 and SQL Express installed at the same time, and both of them work fine. I guess the problem lays in connection string of the database. You can check as following:

Go to database explorer-data connections.
Right click your mdf database and click "modify connection"...
Click the advanced button
Search for the "data source" string
Set the string to refer to your SQL Server2005 instance.

You can take a look at this link:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=124596&SiteId=1.

BTW, if you just want to operate on the database file more directly, you do not need to install SQL Server2005. You can intall "SQL Server Management Studio Express " from here:

http://msdn.microsoft.com/vstudio/express/sql/download/

.

Configuring mail for SQL Server Agent - Problem with Exchange and Outlook on same machine?

I would like to configure e-mail alerts on my SQL Server 2000 box.
However, we also run Exchange on the same machine. I've been told there
could be conflicts/issues having Outlook on the same machine as
Exchange; and apparently, one needs Outlook to configure a mail profile
for SQL Server Agent.

Is there, in fact, anything to worry about? If so, are there any
work-arounds beside moving Exchange to another server? (we've only got
one server, so this is not an option for us at this time).
Thanks.

- Dana<dananrg@.yahoo.com> wrote in message
news:1106142898.187937.44340@.z14g2000cwz.googlegro ups.com...
> I would like to configure e-mail alerts on my SQL Server 2000 box.
> However, we also run Exchange on the same machine. I've been told there
> could be conflicts/issues having Outlook on the same machine as
> Exchange; and apparently, one needs Outlook to configure a mail profile
> for SQL Server Agent.
> Is there, in fact, anything to worry about? If so, are there any
> work-arounds beside moving Exchange to another server? (we've only got
> one server, so this is not an option for us at this time).
> Thanks.
> - Dana

SQL Mail can sometimes be tricky to set up - you can check the MS Knowledge
Base for detailed articles on setup and troubleshooting. This is one
alternative approach:

http://www.karaszi.com/sqlserver/info_no_mapi.asp

I don't know if there are any problems with Exchange and Outlook on the same
box (you might want to ask in an Exchange group), but moving Exchange (or
MSSQL) to a separate server might be a good idea anyway, to avoid possible
resource conflicts. Although if you've been running both together for a
while, presumably that's not an issue for you right now.

Simon

Configuring ASP.NET for Persistant Seesion State Management

Hi,
We have created an ASPState database following the instructions in 311209 in
KB. One part of this is to run a job, ASPState_Job_DeleteExpiredSessions,
every minute to clean up any expired sessions from this database.
Recently we had MOM say that this job was causing blocking problems on the
ASPState db. What are the ramifications of changing the job frequency from 1
minute to longer on using this method?
Thanks
Chris WoodChris Wood wrote:
> Hi,
> We have created an ASPState database following the instructions in 311209 in
> KB. One part of this is to run a job, ASPState_Job_DeleteExpiredSessions,
> every minute to clean up any expired sessions from this database.
> Recently we had MOM say that this job was causing blocking problems on the
> ASPState db. What are the ramifications of changing the job frequency from 1
> minute to longer on using this method?
> Thanks
> Chris Wood
>
Review the execution plan for the delete query that you're running,
create the necessary indexes to eliminate any table or index scans that
the delete statement is doing. This will minimize the locking that is
done to the table.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Tracy,
This is a script provided by MS! You think that I should change it?
Thanks
Chris
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:ecdTMGMtGHA.1948@.TK2MSFTNGP04.phx.gbl...
> Chris Wood wrote:
>> Hi,
>> We have created an ASPState database following the instructions in 311209
>> in KB. One part of this is to run a job,
>> ASPState_Job_DeleteExpiredSessions, every minute to clean up any expired
>> sessions from this database.
>> Recently we had MOM say that this job was causing blocking problems on
>> the ASPState db. What are the ramifications of changing the job frequency
>> from 1 minute to longer on using this method?
>> Thanks
>> Chris Wood
> Review the execution plan for the delete query that you're running, create
> the necessary indexes to eliminate any table or index scans that the
> delete statement is doing. This will minimize the locking that is done to
> the table.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||Chris Wood wrote:
> Tracy,
> This is a script provided by MS! You think that I should change it?
> Thanks
>
Just because it's from Microsoft doesn't mean it's perfect. I'm not
familiar with the script you're using, but I didn't say you should
change the script itself. I suggested that you review the execution
plan, to make sure the proper indexes are in place. You are
experiencing blocking problems during a delete operation. This usually
means that the delete is doing a table or index scan and holding a
higher level lock than necessary. Putting the proper index in place
will eliminate the scan, minimizing the duration of the lock.
Tracy McKibben
MCDBA
http://www.realsqlguy.com

Configuring ASP.NET for Persistant Seesion State Management

Hi,
We have created an ASPState database following the instructions in 311209 in
KB. One part of this is to run a job, ASPState_Job_DeleteExpiredSessions,
every minute to clean up any expired sessions from this database.
Recently we had MOM say that this job was causing blocking problems on the
ASPState db. What are the ramifications of changing the job frequency from 1
minute to longer on using this method?
Thanks
Chris WoodChris Wood wrote:
> Hi,
> We have created an ASPState database following the instructions in 311209
in
> KB. One part of this is to run a job, ASPState_Job_DeleteExpiredSessions,
> every minute to clean up any expired sessions from this database.
> Recently we had MOM say that this job was causing blocking problems on the
> ASPState db. What are the ramifications of changing the job frequency from
1
> minute to longer on using this method?
> Thanks
> Chris Wood
>
Review the execution plan for the delete query that you're running,
create the necessary indexes to eliminate any table or index scans that
the delete statement is doing. This will minimize the locking that is
done to the table.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Tracy,
This is a script provided by MS! You think that I should change it?
Thanks
Chris
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:ecdTMGMtGHA.1948@.TK2MSFTNGP04.phx.gbl...
> Chris Wood wrote:
> Review the execution plan for the delete query that you're running, create
> the necessary indexes to eliminate any table or index scans that the
> delete statement is doing. This will minimize the locking that is done to
> the table.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||Chris Wood wrote:
> Tracy,
> This is a script provided by MS! You think that I should change it?
> Thanks
>
Just because it's from Microsoft doesn't mean it's perfect. I'm not
familiar with the script you're using, but I didn't say you should
change the script itself. I suggested that you review the execution
plan, to make sure the proper indexes are in place. You are
experiencing blocking problems during a delete operation. This usually
means that the delete is doing a table or index scan and holding a
higher level lock than necessary. Putting the proper index in place
will eliminate the scan, minimizing the duration of the lock.
Tracy McKibben
MCDBA
http://www.realsqlguy.com

configuring Active/Active...

My Current configuration is:
Windows 2003, cluster service, SQL 2000 sp3
I have 3 databases I want to run one in the cluster node1 and the other two
databases in the node2.
So, when node1 fail, node2 take the node1 DB and vice-versa.
Is possible? do you know some URL where I can find information about it?
Another question: In the Active/Active my applications always make a
connection to the Virtual Server or to each Instance?
Thanks
AA
Yes, this is possible. You will need separate physical disks for each
installation of SQL. Each instance corresponds to a virtual server so the
SQL connection is to the IP of the virtual server and the port of the
instance. Since each instance is on a separate IP address, you can have all
instances using the same port number. All that is required to create a
second installation is to run the SQL install agaon and create a new
clustered instance using new resources (disks, network name, IP address).
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"AA" <aa@.personal.net.py> wrote in message
news:e93uK5UdEHA.3732@.TK2MSFTNGP11.phx.gbl...
> My Current configuration is:
> Windows 2003, cluster service, SQL 2000 sp3
> I have 3 databases I want to run one in the cluster node1 and the other
two
> databases in the node2.
> So, when node1 fail, node2 take the node1 DB and vice-versa.
> Is possible? do you know some URL where I can find information about it?
>
> Another question: In the Active/Active my applications always make a
> connection to the Virtual Server or to each Instance?
>
> Thanks
> AA
>

Configuring access

How can I let all domain users run reports without adding them one by one
into Report Manager?
ThanksAdd <DOMAIN>\Domain Users and grant Browse Rights.
Or better yet, create a security group that is allowed to view reports and
add this group to the list of users. I.e. if your group was called
"ReportUsers" and the name of my domain is WORKHERE then you would add:
WORKHERE\ReportUsers
=-Chris
"Mark Goldin" <mgoldin@.ufandd.com> wrote in message
news:evt7ufc%23GHA.3352@.TK2MSFTNGP03.phx.gbl...
> How can I let all domain users run reports without adding them one by one
> into Report Manager?
> Thanks
>