Counter settings: machine

Showing posts with label machine. Show all posts

Tuesday, March 27, 2012

count occurances in sql

Hi,

I am trying to count the times a machine has been scanned in to a table. what happens is everytime a product is read at a station it is entered in to the table with the following data

stationid
modelnumber
serialnumber

i want to establish a list of every machine that has been read at station id 15 but not station id 2 or 5, does this make sense? basically to establish what machines are not being read at points a and b but end up at point c.

obviously to do this i need to check the model and serials throughout the table to see if there is another occurance of it against station 2 or 5.

i have done this before but cannot recreate it for the lfie of me!

all help is greatly welcomed :)

Quote:

Originally Posted by 692909824

Hi,

I am trying to count the times a machine has been scanned in to a table. what happens is everytime a product is read at a station it is entered in to the table with the following data

stationid
modelnumber
serialnumber

obviously to do this i need to check the model and serials throughout the table to see if there is another occurance of it against station 2 or 5.

i have done this before but cannot recreate it for the lfie of me!

all help is greatly welcomed :)

Your script should be:

SELECT *
FROM [TABLE]
WHERE serialno NOT IN
(SELECT serialno
FROM [TABLE]
WHERE stationid = 2 or stationid = 5)
ANDstationid =15

Thursday, March 22, 2012

couldn't rename or delete maintenance plan in Management Studio

Hi,
I tried to rename and delete one old maintenance plan which is created by
other DBA and before the machine was renamed. But, I kept getting the
following error. I can rename and delete the maintenance plan I created.
An error has occurred while establishing a connection to the server. When
connecting to SQL server 2005, this failure may be cuased by the fact that
under the default settinfs SQL server does not allow remote connections
(provider: Named Pipes providers, error: 40 - could not open a connection to
SQL server) (Microsoft SQL server, Error: 53)
Shared Memory, TCP and Named Piples are all enabled.
Please advise.
Best Regards,
Lynn
I think the problem is that the maintenance plan use the Local Server
Connection which still point to the old machine name. (I couldn't move this
connection or modify the server name for this connection at all). I add
another connection, but I still couldn't delete this maintenance plan.
Please advise.
Best Regards,
Lynn
"Lynn" wrote:

> Hi,
> I tried to rename and delete one old maintenance plan which is created by
> other DBA and before the machine was renamed. But, I kept getting the
> following error. I can rename and delete the maintenance plan I created.
> An error has occurred while establishing a connection to the server. When
> connecting to SQL server 2005, this failure may be cuased by the fact that
> under the default settinfs SQL server does not allow remote connections
> (provider: Named Pipes providers, error: 40 - could not open a connection to
> SQL server) (Microsoft SQL server, Error: 53)
> Shared Memory, TCP and Named Piples are all enabled.
> Please advise.
> --
> Best Regards,
> Lynn
|||I've been pounding my head with a similar problem. A Server was renamed and
now I can't do anything with the plan.
Any more thoughts?
"Lynn" wrote:
[vbcol=seagreen]
> I think the problem is that the maintenance plan use the Local Server
> Connection which still point to the old machine name. (I couldn't move this
> connection or modify the server name for this connection at all). I add
> another connection, but I still couldn't delete this maintenance plan.
> Please advise.
> --
> Best Regards,
> Lynn
>
> "Lynn" wrote:

Couldn't connect to MSDE

Hi all,

I'm developing smart device application in VB.NET.

I couldn't make the connection with MSDE.

MSDE is on the same machine where i'm developing my apps. & testing the result with emulator. (NOt using RDA or Replication).Simply using ADO.NET commands to select a table from MSDE engine.

Connection strings that i've tried:

In a stand alone System:

1)strconnection = "Server = 10.0.0.7;" & "Data Source =HOME\MYINS,1029;" & "Database = TEST;" & "Integrated Security=sspi;"

2)strconnection = "Server = 10.0.0.7;" & "Data Source =HOME\MYINS,1029;" & "Database = TEST;" & "Integrated Security=sspi;" & "User ID =vino;"& "Password =pavi;"

3)strconnection = "Server = 10.0.0.7;" & "Data Source =HOME\MYINS;" & "Database = TEST;" & "Integrated Security=sspi;" & "User ID =vino;"& "Password =pavi;"

In a Domain :
Server Machine name: FCC
Instance Name : FCC\MYINS

1)connectionString = "Integrated Security=sspi;User ID=DSTA\vino;Password=pavi;Initial Catalog=TEST;Data Source=FCC\MYINS";

2)connectionString = "Integrated Security=false;User ID=vino;Password=pavi;Initial Catalog=TEST;Data Source=FCC\MYINS";

3)connectionString = "Integrated Security=sspi;User ID=DSTA\vino;Password=pavi;Initial Catalog=TEST;Data Source=FCC\MYINS,1043";

4)connectionString = "Integrated Security=false;User ID=vino;Password=pavi;Initial Catalog=TEST;Data Source=FCC\FCC\MYINS,1043";

Errors when using standalone system:

1st connection given me error -> Login failed for user "HOME\Guest. (NOte:ALready i enabled the guest account)
2nd connection ->server not found or access denied.

In a Domain:

server not found or access denied Error.

My Computer Settings:

Computer name :HOME
WorkGroup:MSHOME
Guest account Enabled.
I've two instances in My Enterprise Manager
1) (local)(WIndows NT) - SQL server 2000
2) HOME\MYINS -MSDE instance.

I don't know what to do ? Any other setting are there? I tried in three standalone machines loaded with MSDE. but the same result.

Is there any other setting in Emulator? If so how come SQL server 2000 instance working well?

Please advice me to solve this problem. Nearly 4 days i spent to find the solution.But I couldn't. Kindly suggest me ideas.

Thank You.

Note:
1) Windows apps working well with this connection string.

2) In MSDE , TCP/IP & named Pipes are enabled.
Port NO : 1029 (I've seen it by selecting Properties then N/W Configuration)

3)Connectionis suceessfully established when i used SQL server 2000 instance.
But failed for MSDE.

4)In addition i've configured loopback adapter with valid IP(10.0.0.7).But No improvement with my connection.

1) Is your MSDE instance configured as Windows Authentication or Mixed Auth? Make sure you configure it as Mixed Auth if you want to use user ID/Password.

2) By "Guest account Enabled.", do you mean guest account in SQL Server or Windows? or both?

<<<< 1st connection given me error -> Login failed for user "HOME\Guest. (NOte:ALready i enabled the guest account) >>>>
This error msg means you are able to connect to the server, but failed because of credential. You have not grant access to HOME\Guest in MSDE. (windows authen is used here)

3) Have you checked errorlog or eventlog to get more info?

|||

Hi,

1) I'm using Mixed mode authentication.

2) Actually Guest account in Windows server 2003 was disabled earlier. I Enabled it manually.

3)I didn't chect Eventlog &errorlog. how to check them?

is it like Mycomputer--> Manage >services?

4)I've dirctly connected my PDA with server .it's not pinging.

PDA IP : xxx.xxx.x.101(i've selected VPN connection )

server IP :xxx.xxx.x.100.

In case of emulator, apps running m/c(windows xp) is pinging with server.

But connection not established.

How to make PDA to ping with server? & how to establish a successful connection?

Thanks!!!

Tuesday, March 20, 2012