Considerations when delete records from table.

Hello, I'm developing application which monitors network packets. The monitoring data are saved into table. Monitoring table maintains the data for fixed quantum time,for example during one 1 hour. So, every minute before or after insert new data, I delete the time-expired data. I doubt that the endless delete operation would results in some problems(increasing index,etc..).

Is this mechanism safe to the dbms?

Aren't there round-robin(?) style table?

thats wat OLTP is for.... just keep the update statistics to auto (its default) , if ur using indexes.....also there may be fragmentation issues ...but thats a DBA activity/Db maintainance...

Connfig Replication via Internet

I want to replicate data via Internet using FTP Server, i have SQL 2K with SP3. i set up client network as
- Server alias: my local server's name
- Server Name: ip address on internet
- Network libraries: TCP/IP
- Port : 1433
But i connect using Enterprise Manage to SQL Server then it errors:
A Connection could not be established to Dis-server ( Dis-server is my servername)
Reason: SQL Server does not exist or accessed denied
ConnectionOpen(Connect())..
please help me..tks
Regards
NBtri
from the subscriber can you ping your publisher?
On your publisher and subscriber you have to configure the subsciber and
publisher using client network utility.
Make sure that the publsiher and subscriber are listed in the hosts file
(thanks Paul Ibison for this tidbit of tidbitosity)
Then on your Publisher go to Tools - replication - Configure Publishers,
subscribers, distributors, click on the subscribers tab, and click on the
check box to the right of your subscriber server name. Ensure you are using
a SQL Server account, and enter the subscriber sa (or an account in the
system administrator role) onthe subscriber and its password.
Then on your subscriber, set up a pull subscription.
"NBTri" <anonymous@.discussions.microsoft.com> wrote in message
news:8ABF42AE-6921-4A63-8479-CD7910909F89@.microsoft.com...
> I want to replicate data via Internet using FTP Server, i have SQL 2K with
SP3. i set up client network as
> - Server alias: my local server's name
> - Server Name: ip address on internet
> - Network libraries: TCP/IP
> - Port : 1433
> But i connect using Enterprise Manage to SQL Server then it errors:
> A Connection could not be established to Dis-server ( Dis-server is my
servername)
> Reason: SQL Server does not exist or accessed denied
> ConnectionOpen(Connect())..
>
> please help me..tks
> Regards
> NBtri
>

Connects but network error, Im behind Wingate

Hello.

I'm trying to connect to SQL Server using Enterprise manager. I'm behind a Wingate proxy.

I've configured an alias using TCP/IP, pointing to the (local network) IP of the Wingate box.

On the Wingate box I've set a TCP Mapping service on port 1433, pointing to the IP of the remote SQL Server on port 1433 too.

The error message is:
General network error. Changed language settings to us-english. ConnectionRead(Error SIO_KEEPALIVE_VALS())..

I assume at least *something* is right, as if I change the password to a bogus one I get "Login failed" instead of this network error.

Hope someone can point me in the right direction. Thanks,
- ManuelYou probably need to enable UDP port 1434 as well. See MSDN (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_1zuc.asp) for a more complete explaination.

-PatP|||Hello.

Just added UDP mapping on 1434. Same error.

Read the MSDN article but couldn't figure what else to try. Just in case I didn't make myself clear, I'm trying to connect to a server outside my local network (as opposed to enabling a server on my network to be seen on the internet).

How can I debug this forward? What else can I do?

Thanks again,
- Manuel|||Check the Wingate log, and look to see what traffic is blocked from the workstation headed toward the server's IP address. It should be on port 1433 unless you are using a named instance of SQL Server, but look for anything, just in case.

Triple check to be sure that your Client Network Settings (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_client_7v03.asp) and the server's Server Network Settings (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_2epl.asp) are compatible, especially if they are using a Proxy (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_1y5u.asp).

-PatP|||As referred by Pat ensure both client & server's netlibs are similar, by chance are you running on cluster?

Try to use Named-pipes instead of Tcp/IP.

Information about Orphaned sessions (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_rptconsetup_5gmr.asp) from this mSDN link.

HTH

Connectivity with sql server

The problem what iam facing,is while updating records from
a network system to sql server,the time taken is very high.
I would like to know how to make faster updation of record
to my sql database.
And what role does ODBC play here.and is there any log
file or temporary files created at server end,if i would
like to know the path.and does it got to do anything with
the record updation speed.
I would be a great help for me...!!What type of update are you doing? Is this a one-time thing or a
continuously needed update? What is your table structure, what does your
update statement look like? Do you have indexes on the table? What recovery
mode are you running the database in? How many users are connected to the
server when you run this update? Are there any locking/blocking issues? Lots
of questions, answer them and I'm sure someone can help.
Ray Higdon MCSE, MCDBA, CCNA
--
"ssd" <ssd_myworld@.yahoo.com.sg> wrote in message
news:0e8e01c3deff$e7afc9f0$a601280a@.phx.gbl...

quote:

---

> The problem what iam facing,is while updating records from
> a network system to sql server,the time taken is very high.
> I would like to know how to make faster updation of record
> to my sql database.
> And what role does ODBC play here.and is there any log
> file or temporary files created at server end,if i would
> like to know the path.and does it got to do anything with
> the record updation speed.
> I would be a great help for me...!!

---

|||I got one sql server connected to 5 workstations,A small
vb application which updates 10-15 fileds,submission of
each record is taking 35-40secs,we will be updating 50
records at a time span of 30-45 minutes.
Here the time taken to update each record is pain taking.
How can i over come this problem inorder to submit my
records faster.
And ODBC got to do anything at workstation end,i mean we
got to configure ODBC at workstation.sqlsql

Connectivity Issues - Bizzare

I am trying to connect to a default instance of SQL Server 2000 Enterprise on
a remote network server using ADO.NET objects through ASP.NET Web Application.
The SQL SERVER is on a Windows XP machine (no firewall enabled) with TCP/IP
and Named Pipes enabled
For the test purposes, I created a new Web Form, created a new SqlConnection
in the Server Explorer to the remote database. I test the connection is VS
IDE and everything is fine. I create a SqlDataAdapter on the web form,
generate a dataset, test the dataset and the results are valid. I bind the
SqlDataAdapter to a datagrid and run the webform. I now get the following
error.
System.Data.SqlClient.SqlException: SQL Server does not exist or access
denied.
at System.Data.SqlClient.ConnectionPool.GetConnection (Boolean&
isInTransaction)
at
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnectionString options, Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
at DBConnTest.WebForm1.Page_Load(Object sender, EventArgs e) in
c:\inetpub\wwwroot\dbconntest\webform1.aspx.cs:lin e 39
Hmph! I take the same connection string from the web app, create a win app.
Place a datagrid on the form, do the binding and load the app. Hey Presto! it
works.
I used TCPView (systeminternals.com) and I can see aspnet_wp trying to
create a connection, but its at though SQL Server is rejecting the
connection, although I see no failures in SQL Server.
Any thoughts would be much appreciated.
Andy
Sounds like firewall to me.
As a quick test to see if firewall is blocking port, try this from command
prompt on client machine ->
telnet mysqlmachine 1433
If you can't telnet to 1433, then you have firewall issue.
Matt Neerincx [MSFT]
This posting is provided "AS IS", with no warranties, and confers no rights.
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.
"Andy Furnival" <AndyFurnival@.discussions.microsoft.com> wrote in message
news:40AC00C0-0402-452B-AAC8-F25D97E94ACD@.microsoft.com...
>I am trying to connect to a default instance of SQL Server 2000 Enterprise
>on
> a remote network server using ADO.NET objects through ASP.NET Web
> Application.
> The SQL SERVER is on a Windows XP machine (no firewall enabled) with
> TCP/IP
> and Named Pipes enabled
> For the test purposes, I created a new Web Form, created a new
> SqlConnection
> in the Server Explorer to the remote database. I test the connection is VS
> IDE and everything is fine. I create a SqlDataAdapter on the web form,
> generate a dataset, test the dataset and the results are valid. I bind the
> SqlDataAdapter to a datagrid and run the webform. I now get the following
> error.
> System.Data.SqlClient.SqlException: SQL Server does not exist or access
> denied.
> at System.Data.SqlClient.ConnectionPool.GetConnection (Boolean&
> isInTransaction)
> at
> System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnectionString
> options, Boolean& isInTransaction)
> at System.Data.SqlClient.SqlConnection.Open()
> at DBConnTest.WebForm1.Page_Load(Object sender, EventArgs e) in
> c:\inetpub\wwwroot\dbconntest\webform1.aspx.cs:lin e 39
> Hmph! I take the same connection string from the web app, create a win
> app.
> Place a datagrid on the form, do the binding and load the app. Hey Presto!
> it
> works.
> I used TCPView (systeminternals.com) and I can see aspnet_wp trying to
> create a connection, but its at though SQL Server is rejecting the
> connection, although I see no failures in SQL Server.
> Any thoughts would be much appreciated.
> Andy

Connectivity Issues - Bizzare

I am trying to connect to a default instance of SQL Server 2000 Enterprise o
n
a remote network server using ADO.NET objects through ASP.NET Web Applicatio
n.
The SQL SERVER is on a Windows XP machine (no firewall enabled) with TCP/IP
and Named Pipes enabled
For the test purposes, I created a new Web Form, created a new SqlConnection
in the Server Explorer to the remote database. I test the connection is VS
IDE and everything is fine. I create a SqlDataAdapter on the web form,
generate a dataset, test the dataset and the results are valid. I bind the
SqlDataAdapter to a datagrid and run the webform. I now get the following
error.
System.Data.SqlClient.SqlException: SQL Server does not exist or access
denied.
at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean&
isInTransaction)
at
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnec
tionString options, Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
at DBConnTest.WebForm1.Page_Load(Object sender, EventArgs e) in
c:\inetpub\wwwroot\dbconntest\webform1.aspx.cs:line 39
Hmph! I take the same connection string from the web app, create a win app.
Place a datagrid on the form, do the binding and load the app. Hey Presto! i
t
works.
I used TCPView (systeminternals.com) and I can see aspnet_wp trying to
create a connection, but its at though SQL Server is rejecting the
connection, although I see no failures in SQL Server.
Any thoughts would be much appreciated.
AndySounds like firewall to me.
As a quick test to see if firewall is blocking port, try this from command
prompt on client machine ->
telnet mysqlmachine 1433
If you can't telnet to 1433, then you have firewall issue.
Matt Neerincx [MSFT]
This posting is provided "AS IS", with no warranties, and confers no rights.
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.
"Andy Furnival" <AndyFurnival@.discussions.microsoft.com> wrote in message
news:40AC00C0-0402-452B-AAC8-F25D97E94ACD@.microsoft.com...
>I am trying to connect to a default instance of SQL Server 2000 Enterprise
>on
> a remote network server using ADO.NET objects through ASP.NET Web
> Application.
> The SQL SERVER is on a Windows XP machine (no firewall enabled) with
> TCP/IP
> and Named Pipes enabled
> For the test purposes, I created a new Web Form, created a new
> SqlConnection
> in the Server Explorer to the remote database. I test the connection is VS
> IDE and everything is fine. I create a SqlDataAdapter on the web form,
> generate a dataset, test the dataset and the results are valid. I bind the
> SqlDataAdapter to a datagrid and run the webform. I now get the following
> error.
> System.Data.SqlClient.SqlException: SQL Server does not exist or access
> denied.
> at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean&
> isInTransaction)
> at
> System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConn
ectionString
> options, Boolean& isInTransaction)
> at System.Data.SqlClient.SqlConnection.Open()
> at DBConnTest.WebForm1.Page_Load(Object sender, EventArgs e) in
> c:\inetpub\wwwroot\dbconntest\webform1.aspx.cs:line 39
> Hmph! I take the same connection string from the web app, create a win
> app.
> Place a datagrid on the form, do the binding and load the app. Hey Presto!
> it
> works.
> I used TCPView (systeminternals.com) and I can see aspnet_wp trying to
> create a connection, but its at though SQL Server is rejecting the
> connection, although I see no failures in SQL Server.
> Any thoughts would be much appreciated.
> Andy

Connectivity Issue

I recently posted a few columns on how to connect. I figured a way, through a mapped network drive. Although this has to be temporary for the extreme nature of connecting this way. It will have to do for now. But, I couldn't get around the issue of connecting my Access 2003 to SQL Server 05.

My new question is this: What do I need to do in order for the tables I created on the server side to show in the link tables window?

It gives me all of the other database library mumbo jumbo, but I don't see the two tables I created...

Another question is this: What about when I create other tables on the server side, will I have to repeat the connection process so I can see those tables as well?

Hi,

ok, if you are sure that you are connected to the right database, you will have to grant the appropiate priviledges to the user who is connecting. The metadata is as of SQL Server 2005 secured, which means that you will only see the tables you have currently access to.

For the other question it depends which project type you are using in access. If you are <using an ADP project (which directly talks to the SQL Server) you can just do a refresh in the listing windows of Access and will see the additional tables and objects. If you are using a "normal" access project, you will have to go through the process of adding the new tables through the "Add new linked table" > "Select the datasource" etc.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

About the first issue, even with SQL Server 2005 secured. Those tables I do have access to are not tables that I have created. What does that mean?

The second issue maybe I should use the ADP method for Access. It sounds like the kind of thing I wanted to do in the first place.

Thanks, for the assistance. I am an Oracle person myself so to be introduced to these databases as the norm is somewhat new to me.

|||If you did not craete them and have acces to the tables you are either granted explicit grants on the tables for your login or you are in a group which has the permissions to access the objects (like a role in ORACLE, e.g. the sysdba role/user).

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

I agree, but I don't understand. Why I would not have access to the two tables I created, they are apart of the same instance as the master table, etc.?

I found out also I may have to back away from the ADP version, it seems to be very webby. I don't mind but here is a very secure culture and I don't know if the interested parties would like that kind of exposure. It is on Access now, and I don't care to much for that. I used to create front end VB interfaces for an Oracle backend. Now I am into Access, trying to make this fly with SQL SERVER. I am hoping to move back into VB/.NET (bread & butter, lol) that maybe the next move.

|||Good luck :-)

Jens K. Suessmeyer.

http://www.sqlserver2005.de

ConnectionOpen (PreLoginHandshake()). General Network Error

Hi all,
I'm getting the following error on my SQL on a local machine when running a
client program that connects to sql server located at the same machine. What
does it means? Do i have to configure in SQL settings?
[DBNETLIB]ConnectionOpen (PreLoginHandshake()). General Network Error.
thanks,
joelNormally this message would indicate a timeout of some kind attempting to
connect. Open the SQL Client Network Utility and see if Shared Memory is
enabled. If it is not enable it and see if the problem goes away. Local
connections by default should use shared memory so it would appear that
this is not enabled.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Connection to SQL Server with network login id when not logged

I have a scheduled task that executes a program that, among other
stuff, every morning connects to a SQL Server that requires a login by
network login id. The problem is that, even if that scheduled task runs
as the network user, it doesn't work if that user is not logged on.
Is it any way to make ir connect when not logged?
Thanks in advance.
By "scheduled task" I assume that to mean that it is set to run using SQL
Agent. If so, then you need to assign the SQL Agent service to run as a
specific windows domain id and that id in turn needs to be granted access to
your SQL Server instance and database(s).
--Brian
(Please reply to the newsgroups only.)
<axl@.todojuegos.com> wrote in message
news:1123149165.623223.184430@.g44g2000cwa.googlegr oups.com...
> I have a scheduled task that executes a program that, among other
> stuff, every morning connects to a SQL Server that requires a login by
> network login id. The problem is that, even if that scheduled task runs
> as the network user, it doesn't work if that user is not logged on.
> Is it any way to make ir connect when not logged?
> Thanks in advance.
>

Connection to SQL Server with network login id when not logged

I have a scheduled task that executes a program that, among other
stuff, every morning connects to a SQL Server that requires a login by
network login id. The problem is that, even if that scheduled task runs
as the network user, it doesn't work if that user is not logged on.
Is it any way to make ir connect when not logged?
Thanks in advance.By "scheduled task" I assume that to mean that it is set to run using SQL
Agent. If so, then you need to assign the SQL Agent service to run as a
specific windows domain id and that id in turn needs to be granted access to
your SQL Server instance and database(s).
--Brian
(Please reply to the newsgroups only.)
<axl@.todojuegos.com> wrote in message
news:1123149165.623223.184430@.g44g2000cwa.googlegroups.com...
> I have a scheduled task that executes a program that, among other
> stuff, every morning connects to a SQL Server that requires a login by
> network login id. The problem is that, even if that scheduled task runs
> as the network user, it doesn't work if that user is not logged on.
> Is it any way to make ir connect when not logged?
> Thanks in advance.
>

Connection to SQL Server is lost

Hi,
I am having a problem with SQL Server connectivity when
the network cable is unplugged while a DB connection is
ON. SQL Server gives me some errors like
"ConnectionWrite (send()).
State:01000,Native:10054,Origin:[Microsoft][ODBC SQL
Server Driver][Shared Memory]"

&

"General network error. Check your network documentation.
State:08S01,Native:11,Origin:[Microsoft][ODBC SQL Server
Driver][Shared Memory]"

Weird thing is that am not connecting to SQL Server over
the LAN, its right here in the same machine where
Application is running.

Machine is running Win XP and SQL Server 7.0 SP3

Any help in this matter is highly appreciated.

Thanks,
RajeshHi Rajesh!

You probably use odbc to connect and in you odbc entry you dont have entered local (or just a dot). Then it believes that the database is on another server.

/Mada

Connection String for remote Sql server

Hi,

I trying to connect to the sql server in the network. The sqlserver is in the machine called "pinnacle". I am Using the following connection string to connect and i am getting the error "Sql server does not exist or Access denied"

Public databaseConnectionStringSQLAsString = "Data Source=(pinnacle);Initial Catalog=cms;Trusted_connection=True;User Id=dbuser;Password=password"

Any help will be appriciated.

Reagrds,

Thiyasoft

Try to change Trusted_connection to false and you don't need the parentheses around the server name..|||I tried , still i got the same error.|||

If you are trying to connect to a remote sql server 2005 then you may have to set up the server to allow remote connections.

http://www.datamasker.com/SSE2005_NetworkCfg.htm

|||

First make sure your connection string is correct. You can checkwww.connectionstrings.com. Use correct value for Data Source property. SQL Server Instance name is the machine name if it is a default instance, and in case of named instance the SQL instance name should be machinename/SQLInstancename (e.g. myserver/SQLEXPRESS).

And you also need to check remote connections on the remote SQL instance, please check this KB.

If connect via the SQL instance name still fails with error "SQL Server does not exist...", you can try to force the connection using TCP/IP network library as mentioned inthis post.

Connection String Error

Hi Team

I am new to WEB sites as I normal work with Win apps.

I am using Server 2003 with SQL server 2005 Delevoper.

The server is on my own network in the same room..

I have made a new Web Site in Visual Studio 2005 DotNet Framework 2.0. It runs fine on testing.

I can log in and move around just fine. BUT when I publish it to the server the following happens:

I Can find the web site in internet explore from my Domain name (www.rbsoft.com.au) or Static IP. I get the default page up ok.

Then when I click on login I will get the login page. So I fill it in and click Login.

Then I get the follwing Error message.

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)

The Connection string is as follows:

<connectionStrings>

<add name="ConnectionString" connectionString="Data Source=RBSOFT-SERVER\MSSQLSERVER;AttachDbFilename=\App_Date\ASPNETDB.MDF;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>

</connectionStrings>

I seems to me that the web site can not find the ASPNETDB.MDF database.

I can see the database on the server with "SQL Server Management Studio Express"

I spent many hours trying to find out why it will not work.

Can any one help me - Please

Regards

Ron B

please check spelling of \App_Date\*.mdf
DatE or Data

Connection Problem >please help.

Hi,

My sql server (MSDE) is in different machine (192.168.0.3) from where my web server (192.168.0.2) but they both are in same network. I have the following in my web.config to file

<add key="ConnectionString" value="server=192.168.0.3;Trusted_Connection=True;database=InetDb" /
I get the following error:

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

Is there a solution to it?
Please help.You could set the {uid} and {password} properties for a permission specific SQL account.|||thanks but you are talking to a beginner. I am not sure how but I am trying.
How do I set a user and password in MSDE|||Do you have administrator privliges on both of the server?|||I have this same problem, please msg me when you have solved it.|||You can take a look at these 2 links from MSDN:

http://msdn.microsoft.com/netframework/downloads/sdkmsde/default.aspx

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_84xl.asp

if your MSDE is on different PC, you need to use the DISABLENETWORKPROTOCOLS=0
switch during installation.

hope this helps,

Lei Xu
lei_xu@.hotmail.com|||Hi,

I administrate both servers. Home networking, you know..

Not sure what part I am missing but I still haven't been able to figure it out yet.

Regards,|||limsuwan

I had a similar problem and here is what worked for me.

I changed the setting to Mixed Mode from Windows authentication following the direction of the article at:

http://support.microsoft.com/?kbid=322336#2

Once I restarted my computer, the app came up fine.

My final web.config file looks like so:

<configuration>
<appSettings>
<add key="constring"
value="Server=(local);Database=AspNetJobs;UID=AspNETJobsUser;PWD=secret" />
</appSettings>
<system.web>
<authentication mode="Forms" >
<forms name=".ASPNETJOBS"
loginUrl="/aspnetjobs/site/password/login.aspx" />
</authentication>
</system.web>
</configuration
I am a newbie to .net development as well I had spent a couple of days trying to figure out this problem by going through the forums.

Hope this helps|||Thank you so much.
Regares,

Connection Problem - MSDE 2000 on Peer to Peer Network

I have MSDE installed on one of my computers in my peer to peer network (all
computers XP Professional). All computers on the network can see each
other. However, I cannot use Query Analyzer or Enterprise Manager to
connect to MSDE except from the computer that contains MSDE.
Is it possible to connect to MSDE using Query Analyzer etc, in this
scenario.
ThanksI'll be honest, I have yet to work with MSDE but here are some links that
may help
http://support.microsoft.com/defaul...kb;en-us;319930
http://support.microsoft.com/defaul...kb;en-us;325003
HTH
Ray Higdon MCSE, MCDBA, CCNA
--
"Sid Sarin" <sidsarin123@.earthlink.net> wrote in message
news:zByYb.9378$W74.78@.newsread1.news.atl.earthlink.net...
> I have MSDE installed on one of my computers in my peer to peer network
(all
> computers XP Professional). All computers on the network can see each
> other. However, I cannot use Query Analyzer or Enterprise Manager to
> connect to MSDE except from the computer that contains MSDE.
> Is it possible to connect to MSDE using Query Analyzer etc, in this
> scenario.
> Thanks
>|||By default, MSDE 2000 SP3 only has shared memory (LPC) enabled. To allow
connections from remote machines you have to enable TCP and/or named pipes
through the server network utility (svrnetcn.exe).
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.