count number of connections in sql

This is probably a newbie quesiton, but I would like to be able to count how
many users connect to my db for evvery 30 minutes. How may I do this within
sql 2k?
Thank you in advanceSELECT COUNT(DISTINCT spid) FROM master..sysprocesses WHERE spid > 50
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Carl Henthorn" <CarlHenthorn@.discussions.microsoft.com> wrote in message
news:06F88966-654C-449D-8085-9F87DC7455DF@.microsoft.com...
> This is probably a newbie quesiton, but I would like to be able to count
> how
> many users connect to my db for evvery 30 minutes. How may I do this
> within
> sql 2k?
> Thank you in advance|||Thank you for responding! I think that this code will give me a snapshot of
how many are connected at a given time, but I need to know how many total
have connected in the last 30 minutes. perhaps I can place a trigger on this
table that updates a count in another table whenever a new process (where
spid>50) is spawned?
"Aaron [SQL Server MVP]" wrote:

> SELECT COUNT(DISTINCT spid) FROM master..sysprocesses WHERE spid > 50
> --
> This is my signature. It is a general reminder.
> Please post DDL, sample data and desired results.
> See http://www.aspfaq.com/5006 for info.
>
> "Carl Henthorn" <CarlHenthorn@.discussions.microsoft.com> wrote in message
> news:06F88966-654C-449D-8085-9F87DC7455DF@.microsoft.com...
>
>|||No trigger on system tables, sorry. You will have to poll the table
constantly. Plus, if I connect and get assigned spid 52, you poll, then I
disconnect and someone else connects and gets assigned 52, you won't see the
difference unless you compare the deltas in all columns (which still might
not yield a discrepancy).
You might consider tracking this more from the application side, e.g. if you
have a GUI where people are logging in, then in the stored procedure that
checks their credentials, log the connection in some table. SQL Server
isn't going to provide you this kind of information directly.
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Carl Henthorn" <CarlHenthorn@.discussions.microsoft.com> wrote in message
news:D84485D0-59F2-4298-89DC-04AFDC5B29DA@.microsoft.com...
> Thank you for responding! I think that this code will give me a snapshot
> of
> how many are connected at a given time, but I need to know how many total
> have connected in the last 30 minutes. perhaps I can place a trigger on
> this
> table that updates a count in another table whenever a new process (where
> spid>50) is spawned?
> "Aaron [SQL Server MVP]" wrote:
>|||Thank you for your help!!
"Aaron [SQL Server MVP]" wrote:

> No trigger on system tables, sorry. You will have to poll the table
> constantly. Plus, if I connect and get assigned spid 52, you poll, then I
> disconnect and someone else connects and gets assigned 52, you won't see t
he
> difference unless you compare the deltas in all columns (which still might
> not yield a discrepancy).
> You might consider tracking this more from the application side, e.g. if y
ou
> have a GUI where people are logging in, then in the stored procedure that
> checks their credentials, log the connection in some table. SQL Server
> isn't going to provide you this kind of information directly.
> --
> This is my signature. It is a general reminder.
> Please post DDL, sample data and desired results.
> See http://www.aspfaq.com/5006 for info.
>
> "Carl Henthorn" <CarlHenthorn@.discussions.microsoft.com> wrote in message
> news:D84485D0-59F2-4298-89DC-04AFDC5B29DA@.microsoft.com...
>
>

Couldn't connect to reports

Hi,

I'm not able to browse through http://localhost/reports.

When I'm trying to connect it gives me "Server Error in '/Reports' Application."At the same time I'm able to view Reportserver.At the same time I'm able to view Reportserver.(i.e)http://localhost/reportserver

please can anyone suggest me some solution to this problem..

Server Error in '/Reports' Application.

---

The trust relationship between the primary domain and the trusted domain failed.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.SystemException: The trust relationship between the primary domain and the trusted domain failed.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SystemException: The trust relationship between the primary domain and the trusted domain failed.

]

System.Security.Principal.NTAccount.TranslateToSids(IdentityReferenceCollection sourceAccounts, Boolean& someFailed) +1167

System.Security.Principal.NTAccount.Translate(IdentityReferenceCollection sourceAccounts, Type targetType, Boolean& someFailed) +42

System.Security.Principal.NTAccount.Translate(IdentityReferenceCollection sourceAccounts, Type targetType, Boolean forceSuccess) +46

System.Security.Principal.WindowsPrincipal.IsInRole(String role) +205

System.Web.Configuration.AuthorizationRule.IsTheUserInAnyRole(StringCollection roles, IPrincipal principal) +120

System.Web.Configuration.AuthorizationRule.IsUserAllowed(IPrincipal user, String verb) +300

System.Web.Configuration.AuthorizationRuleCollection.IsUserAllowed(IPrincipal user, String verb) +191

System.Web.Security.UrlAuthorizationModule.OnEnter(Object source, EventArgs eventArgs) +3403086

System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92

System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

---

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210

Hi,

What are the security settings in IIS for both sites?

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

Hi,

we had given full control to the administrators as well as system users.

And read and execute permission to reportserveruser as well as webservice user.

Thanks

Anandhi

|||

That is for NTFS security. What are the permissions set on the virtual directory?

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

Hi,

Execute Scripts only permission for both

Thanks

Anandhi

|||

I mean in the Directory Security Tab.

There you can see whether the site is accessed via:

anonymous (+ which account)|||

Sorry for misunderstanding,

We have chosen for Integrated Windows Authentication

Anonymous is not enabled.

Thanks,

Anandhi

|||

Is this the same as for the report server?

By default this virtual directory is mapping to a folder in your C:\Program Files\... (for me it is C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportManager). This means that the users of the http://localhost/reports url, must have read permissions to it.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

Permissions for both reports and reportserver are one and the same.Read permission is there.And it is mapped to the folder as you had specified.

Thanks,

Anandhi

|||

Did you migrate from one domain to another?

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

No we havn't migrated to any other domain.

Thanks,

Anandhi

Couldn't connect to my server from client

I have a communication error from my client when I try to connect to my SQL
server 2000 SP4 on a Windows 2003 server. Is there any method that I can get
to see if I don't miss something when I have made the installation on the
server part ?
Every help will be welcome
Regards,
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...curity/200609/1I dont believe that SQL server keeps track of that type of information
unless you have C2 auditing enabled. You could also pick that up in a trace
file had you been tracing.
http://www.microsoft.com/technet/pr...tain/sqlc2.mspx
I could be wrong though. Does anyone else have any information?
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
"Silver via droptable.com" <u26873@.uwe> wrote in message
news:669141b5c2b48@.uwe...
>I have a communication error from my client when I try to connect to my SQL
> server 2000 SP4 on a Windows 2003 server. Is there any method that I can
> get
> to see if I don't miss something when I have made the installation on the
> server part ?
> Every help will be welcome
> Regards,
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...curity/200609/1
>sql

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!!!

Couldn't connect server

Hi to all,
When I try to connect SQL 2000 Enterprise client with SQL
Server 2000 Enterprise Server , the following error
message displayed.
Unable to connect to server
Server:Msg 17,Level 16,State 1
Microsoft ODBC SQL Server Driver TCP/IP Sockets SQL
Server does not exist or access denied
How can i solve this problem?
Database Server configuration:
Windows Server 2003 with SQL Server 2000 Enterprise
Edition
Advance thankx
Sankar.First, verify you can make a network connection like a mapped drive to the
server.
Second, open Client Network Utility on your workstation, Server Network
Utility on the server (both programs are in the SQL Program group) and
verify you are both listening on the same protocols in the same order.
Lastly, you should verify MSSQLServer service is running on the server and
that there are no firewalls in between your computers which might be
blocking ports.
****************************************
***************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
****************************************
***************************
"Sankar" <anonymous@.discussions.microsoft.com> wrote in message
news:04c801c3d8ea$36ab78e0$a301280a@.phx.gbl...

quote:

---

> Hi to all,
> When I try to connect SQL 2000 Enterprise client with SQL
> Server 2000 Enterprise Server , the following error
> message displayed.
>
> Unable to connect to server
> Server:Msg 17,Level 16,State 1
> Microsoft ODBC SQL Server Driver TCP/IP Sockets SQL
> Server does not exist or access denied
> How can i solve this problem?
> Database Server configuration:
> Windows Server 2003 with SQL Server 2000 Enterprise
> Edition
>
> Advance thankx
> Sankar.

---

|||Also, since you are attempting a TCP?IP connection verify that you can ping
the SQL Server machine by name. If not, try specifying the SQL Server
machine name ip address as the server name when attempting to connect. If
the first fails but the second succeeds then there is a name resplution
problem. If the second fails as well then there could be a network related
problem that is preventing the client from accessing the SQL Server.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||> the SQL Server machine by name. If not, try specifying the SQL Server

quote:

---

> machine name ip address as the server name when attempting to connect. If
> the first fails but the second succeeds then there is a name resplution
> problem. If the second fails as well then there could be a network related
> problem that is preventing the client from accessing the SQL Server.

---

I have the same problem but I can ping the machine.
Mike Collier BSc( Hons) Comp Sci
Get a copy of AdoAnywhere Browser FREE if you register for the forum
quickly...
http://www.adoanywhere.com/forum
"Rand Boyd [MS]" <rboyd@.onlinemicrosoft.com> wrote in message
news:h0mDbBU2DHA.2184@.cpmsftngxa07.phx.gbl...

quote:

---

> Also, since you are attempting a TCP?IP connection verify that you can

---

ping

quote:

---

> the SQL Server machine by name. If not, try specifying the SQL Server
> machine name ip address as the server name when attempting to connect. If
> the first fails but the second succeeds then there is a name resplution
> problem. If the second fails as well then there could be a network related
> problem that is preventing the client from accessing the SQL Server.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>

---

|||Work through this article:
328306 INF: Potential Causes of the ("SQL Server Does Not Exist or Access
http://support.microsoft.com/?id=328306
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

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!!!

Could Someone Help me to Config SQL2005 to Connect to my Host Database Server

Hi

I'm new this .I' using SQL 2005 VWD05.Could some body tell me how to upload to my host server database to to run a membership user account.I dont know what are the procedure to do on my pc in order to transfer the file on the database.

Thanks

I'm not sure what's your exact meaning, but if you want to connect to a remote SQL Server (that's a SQL Server on a different machine rather than the client website application machine), you need to configure the connection string used by the membership provider. For more information, you can refer to this article:

http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx

And if you want to upload a existing database file which is being used by your website to the remote SQL Server, you'd better copy the database file to the local disk on the remote SQL machine, and then have the database file attached to the SQL intance.

|||

I'm trying run a membership page using the createuserwizard.So how do you upload to the database on

the host server inorder to run the createusewizard to accept new account.

|||Lori could you give me a walk through example on how to create a blank instance?|||

bigmike40:

Lori could you give me a walk through example on how to create a blank instance?

ScottGu made clearly answer to this question on the link I post The blank instance here just mean a new database without database objects required by membership management--this can be a newly created database or some existing database. So you can use Enterprise Manager/Management Studio to create a new database, and then use aspnet_regsql.exe to create database objects on the newly created database. If you want to use existing database on the remote SQL Server, you can move the database to the remote SQL Server using Backup/Restore or Detach/Attach. Here are some useful links for moving database:

Move database with Backup/Restore:http://msdn2.microsoft.com/en-us/library/ms190436.aspx

Move database using Detach/Attach:http://msdn2.microsoft.com/en-us/library/ms187858.aspx

|||Ok i have a question.Are you suppose to upload the data explorer files... in vwd in order for the createuserwizard to work, or just the app data folder|||Sorry I'm not familiar with what you said "upload data explorer files". However to use CreateUserWizard control you need to connect to an available SQL database. So if you want to use the existing database file on the remote SQL database, you'd better copy the database file to the local disk on the remote SQL machine so that the database file can be attached to the SQL instance.|||

I'm sorry lori but i'm a newbei and some to the term i don't understand ,so can be a little more specifc on what u mean byif you want to use the existing database file on the remote SQL database, you'd better copy the database file to the local disk on the remote SQL machine so that the database file can be attached to the SQL instance.

|||OK, when you connect to a SQL database, first you need to login to the SQL instance (specified in Data Source property in connection string), right? And then you can use Database property to access an existing database on the SQL instance (for example pubs, tempdb); or use AttachDBFilename to attach a database and then access the attached database (note currently AttachDBFilename must points to a local database file, UNC, network path, HTTP are not supported), this is what I mean "using an existing database file". Apparently, no matter which database you're going to use, the database file must be on the local disk of the SQL machine, that's why I say "copy database file to the local disk on the SQL machine"|||

Would this help my CreateUserWizard to configure and create new user account ? Because i cannot

Get the CreateUserWizard to work on my host server whenever... i hit the submit button it give me an error

But it work fine on my local machine

thanks

|||What's the error you got? Have you configure the membership database connection according to theScottGu's article?|||

Iori i'd like to thank you for taking the time on helping me.For the past month i've trying to get my project to work, but so far no luck.I did try setting up VWD the way scott did , but for some reason when i ran the wizard PUBS, ASPNET, NORTWIND ISSUE TRACKER STARTERKIT, doesn't shows up in the drop down box ..But the others components are listed.I do belive that my problem is that my database is not settup properly. In order to settup my database, do i need to download any other software in order for all the missing componets to show up in the drop down box. I think u did explain it another thread that you did that precedure before. So can you tell me how you went about doing setting up the database.

Thanks you

|||

bigmike40:

but for some reason when i ran the wizard PUBS, ASPNET, NORTWIND ISSUE TRACKER STARTERKIT, doesn't shows up in the drop down box ..But the others components are listed.I do belive that my problem is that my database is not settup properly.

Nevermind, it's my pleasure to share your issue Did you mean you can connect to the remote SQL Server in the aspnet_regsql.exe wizard, but some existing databases (PUBS, ASPNET, NORTWIND ISSUE TRACKER STARTERKIT) on the remote SQL instance don't show up? Then what's the meaning of "others components are listed"? Did you mean other databases on the remote SQL can be listed? If so, that's really strange, as I know there is no such database setting to control the listed databases in the aspnet_regsql wizard. Are you sure the permission setting of the account you're using is proper on the remote SQL instance? Can you connect to the remote SQL instance using this account?

|||

I'm talking about the page where it say to select server and database on Scott blog.In the dropdown list he as

appservers,

ASPNET

Issue Tracker Kits

Master

model

msdb

Northwind

pubs

Those are the componets that are listed under database in Scott blogs

I did settup my config, but northwind, pubs, aspnet and the tracker kit didnt show up.

is it suppose to show up in the dropdown menu like how scott as it listed ?

And as far as can i connect to a remote SQL instance the answer is yes

On my host server i notice that there is nothing listed there in the database.

But my database name is listed in vwd and when hit test connection it said connected, so it seems that i can connect to myhost database, but i think that the info some how is not transfering over there some how.My project works

fine on my local machine but once i uploaded it on the server the CreateUserWizard doesn't work but all the other pages work fine. I belive that all the server control componets doesnt work on the server

I'm using WEB.com as my Host provider and the tech support don't seem to understaand anything about ASPNET 2.0

I think i might just get a better hosting company that don't out source their tech support

Thanks

|||

After trying to follow Scott config i cannot get this screen.

Step 3: Point your web.config file at the new SQL Database

ASP.NET 2.0 now supports a new section in your web.config file called “<connectionStrings>” which (not too surprisingly) are used to store connection strings. One nice thing from an administration perspective is that the new ASP.NET Admin MMC Snap-in now provides a GUI based way to configure and manage these:

could not upload sqljdbc driver

Hello;
I failed to connect with my database, it give me the massage as following;

Cannot load the SQL driver. Include it in your classpath

Could anyone tell me why? Thanks

And i am using the Microsoft SQL server 2000, Java 2 runtime enviroment and Microsoft SQL Server 2005 JDBC Driver now.

In the user varible, i set a path for the java run time as "c:\Program Files\Java\j2re1.4.2\javaws"
and CLASSPATH =.;C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.1\enu\sqljdbc.jar for the JDBC Driver.

and i also tried
1)
-classpath =.;"C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.1\enu\sqljdbc.jar"

2)i moved the file of the sqljdbc.jar to a path as c:\temp

then i try it again as following;

varible name: -classpath
value: ",;C\temp\sqljdbc.jar"

They are still not work

but it does not work

and my code as following;

public MyTest()
{

//information of our connection
//the url of the database: protocol:subprotocol:subname:computer_name:port:database_name
String strUrl = "jdbc:sqlserver://localhost;user=xx;password=xxxx";

//user name and password
String strUser = "xx";
String strPass = "xxx";

//try to load the driver
try {

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
}
catch (ClassNotFoundException e) {
System.out.println( "Cannot load the SQL driver. Include it in your classpath.");
System.exit( -1);
}

//a null reference to a Connection object
c = null;
try {
//open a connection to the database
c = DriverManager.getConnection( strUrl);

}
catch (SQLException e) {
System.out.println("Cannot connect to the database. Here is the error:");
e.printStackTrace();
System.exit( -1);
}
//create a statement object to execute sql statements

displayInformation();
}

By the way, how i can delete a system variable?
i set the classpath for the sqljdbc in system variable section, but i want to delete it, but when i click the delete button, it does not has reaction. Do you known i i can solve this problem? ThanksCan you give me the whole string you are using to execute this. Have you tried running this with Eclipse?

Could not open a connection to SQL server error on Vista

Hey,

After install Visual Studio 2005 (with SQL sever express) on recent Vista build, trying to connect to a local sse database file from Data Source Window (accessible from Data/Show data source window) gives this error:

Microsoft Visual Studio

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

OK

No issues if we install Visual Studio 2005 on WinXP or W2k3.

Is there any configuration we need to set on vista to allow sql connection?

Thanks,

Mei

Not having tried Vista I don't know if there are special issues there, but by default SQL Server instances are installed with the external interfaces disabled. Use SQL Server Configuration Manager to enable the protocols (if they are not enabled already). This can also be done with the SQL Server Surface Area Configuration tool.

If this does not help, see my blog (www.betav.com\blog\billva)

|||

You will have to enable SQLBrowser service.

See more details here:

http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

|||

I have the same problem. If you have found a solution to the problem, then let me know.

Kindly

Peer Larsen, DK

Could not open a connection to SQL server error on Vista

Hey,

After install Visual Studio 2005 (with SQL sever express) on recent Vista build, trying to connect to a local sse database file from Data Source Window (accessible from Data/Show data source window) gives this error:

Microsoft Visual Studio

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

OK

No issues if we install Visual Studio 2005 on WinXP or W2k3.

Is there any configuration we need to set on vista to allow sql connection?

Thanks,

Mei

Not having tried Vista I don't know if there are special issues there, but by default SQL Server instances are installed with the external interfaces disabled. Use SQL Server Configuration Manager to enable the protocols (if they are not enabled already). This can also be done with the SQL Server Surface Area Configuration tool.

If this does not help, see my blog (www.betav.com\blog\billva)

|||

You will have to enable SQLBrowser service.

See more details here:

http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

|||

I have the same problem. If you have found a solution to the problem, then let me know.

Kindly

Peer Larsen, DK

Could not load the DLL xpstar90.dll

I have inherited a sql server 2005 installation (not working) and although i can connect to the server using studion express, as soon a i try to do anything like create a new database i get loads of errors claiming 'Could not load the DLL xpstar90.dll'.

the dll exists and appears to have a reasonable set of security set on it, so i am stumped as to where to go next to disnose the problem.

any suggestions?

regards

TheMightyPuzzled

Hi

I'm new working whith sql server 2005 and I have the same error too.

What do you do to resolve this error whit de xpstart90.dll?

PD: I don't find the xpstart90.dll on the specific folder..

regards.

Cesar...

|||

i never did fix the problem - i still have a machine with a non-functional sql server! Found another machine on the network for the time being. Something to return to in a quiet time.

regards

|||Thanks for all.

Could not load the DLL xpstar90.dll

I have inherited a sql server 2005 installation (not working) and although i can connect to the server using studion express, as soon a i try to do anything like create a new database i get loads of errors claiming 'Could not load the DLL xpstar90.dll'.

the dll exists and appears to have a reasonable set of security set on it, so i am stumped as to where to go next to disnose the problem.

any suggestions?

regards

TheMightyPuzzled

Hi

I'm new working whith sql server 2005 and I have the same error too.

What do you do to resolve this error whit de xpstart90.dll?

PD: I don't find the xpstart90.dll on the specific folder..

regards.

Cesar...

|||

i never did fix the problem - i still have a machine with a non-functional sql server! Found another machine on the network for the time being. Something to return to in a quiet time.

regards

|||Thanks for all.

Could not find file 'C:\WINDOWS\TEMP\

When I try to connect to the reporting server using sql server management studio, I get the following error

TITLE: Connect to Server

Cannot connect to hq-v-w2k3-rpt0.

ADDITIONAL INFORMATION:

System.Web.Services.Protocols.SoapException: Server was unable to process request. > System.IO.FileNotFoundException: Could not find file 'C:\WINDOWS\TEMP\7cxlkihr.dll'.
File name: 'C:\WINDOWS\TEMP\7cxlkihr.dll'
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share)
at Microsoft.CSharp.CSharpCodeGenerator.FromFileBatch(CompilerParameters options, String[] fileNames)
at Microsoft.CSharp.CSharpCodeGenerator.FromSourceBatch(CompilerParameters options, String[] sources)
at Microsoft.CSharp.CSharpCodeGenerator.System.CodeDom.Compiler.ICodeCompiler.CompileAssemblyFromSourceBatch(CompilerParameters options, String[] sources)
at System.CodeDom.Compiler.CodeDomProvider.CompileAssemblyFromSource(CompilerParameters options, String[] sources)
at System.Xml.Serialization.Compiler.Compile(Assembly parent, String ns, CompilerParameters parameters, Evidence evidence)
at System.Xml.Serialization.TempAssembly.GenerateAssembly(XmlMapping[] xmlMappings, Type[] types, String defaultNamespace, Evidence evidence, CompilerParameters parameters, Assembly assembly, Hashtable assemblies)
at System.Xml.Serialization.TempAssembly..ctor(XmlMapping[] xmlMappings, Type[] types, String defaultNamespace, String location, Evidence evidence)
at System.Xml.Serialization.XmlSerializer.FromMappings(XmlMapping[] mappings, Evidence evidence)
at System.Web.Services.Protocols.SoapServerType..ctor(Type type, WebServiceProtocols protocolsSupported)
at System.Web.Services.Protocols.SoapServerProtocol.Initialize()
at System.Web.Services.Protocols.ServerProtocolFactory.Create(Type type, HttpContext context, HttpRequest request, HttpResponse response, Boolean& abortProcessing)
End of inner exception stack trace (Microsoft.SqlServer.Management.UI.RSClient)

It was working until today. nothing changed except I got a microsoft update, could that have caused it?

Nevermind. There must have been something going on in my environment becuase I got another update Update for SQL Server 2005 (KB 932557) and now its fixed.

|||

Hi,

Could you please five the complete url where we can get the this update please. Thanks in advance for you help.

Thanks & Regards,

Venkat.

Could not find file 'C:\WINDOWS\TEMP\

When I try to connect to the reporting server using sql server management studio, I get the following error

TITLE: Connect to Server

Cannot connect to hq-v-w2k3-rpt0.

ADDITIONAL INFORMATION:

System.Web.Services.Protocols.SoapException: Server was unable to process request. > System.IO.FileNotFoundException: Could not find file 'C:\WINDOWS\TEMP\7cxlkihr.dll'.
File name: 'C:\WINDOWS\TEMP\7cxlkihr.dll'
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share)
at Microsoft.CSharp.CSharpCodeGenerator.FromFileBatch(CompilerParameters options, String[] fileNames)
at Microsoft.CSharp.CSharpCodeGenerator.FromSourceBatch(CompilerParameters options, String[] sources)
at Microsoft.CSharp.CSharpCodeGenerator.System.CodeDom.Compiler.ICodeCompiler.CompileAssemblyFromSourceBatch(CompilerParameters options, String[] sources)
at System.CodeDom.Compiler.CodeDomProvider.CompileAssemblyFromSource(CompilerParameters options, String[] sources)
at System.Xml.Serialization.Compiler.Compile(Assembly parent, String ns, CompilerParameters parameters, Evidence evidence)
at System.Xml.Serialization.TempAssembly.GenerateAssembly(XmlMapping[] xmlMappings, Type[] types, String defaultNamespace, Evidence evidence, CompilerParameters parameters, Assembly assembly, Hashtable assemblies)
at System.Xml.Serialization.TempAssembly..ctor(XmlMapping[] xmlMappings, Type[] types, String defaultNamespace, String location, Evidence evidence)
at System.Xml.Serialization.XmlSerializer.FromMappings(XmlMapping[] mappings, Evidence evidence)
at System.Web.Services.Protocols.SoapServerType..ctor(Type type, WebServiceProtocols protocolsSupported)
at System.Web.Services.Protocols.SoapServerProtocol.Initialize()
at System.Web.Services.Protocols.ServerProtocolFactory.Create(Type type, HttpContext context, HttpRequest request, HttpResponse response, Boolean& abortProcessing)
End of inner exception stack trace (Microsoft.SqlServer.Management.UI.RSClient)

It was working until today. nothing changed except I got a microsoft update, could that have caused it?

Nevermind. There must have been something going on in my environment becuase I got another update Update for SQL Server 2005 (KB 932557) and now its fixed.

|||

Hi,

Could you please five the complete url where we can get the this update please. Thanks in advance for you help.

Thanks & Regards,

Venkat.

Could not connect to Subscriber

I am using Sql server replication wizard and it create
publisher, subscriber and Distributor successfully and
also apply initial snapshot and transfer data. but when i
try to synchronize manually it returns error "The process
could not connect to subscriber "MySubscriber". i am using
windows authentication.
Hi
I think u are not on the same domain. Try to implementing by SQL
authentication. I have done every thing successfully. It must be the error
of SQL Agent. i am also working on relication these days so i m also seeking
any thing/error/problem related to replication. I think u are missing some
thing during wizard.
Regards,
-Imran Iqbal
"Saima" <ucoxk@.yahoo.com> wrote in message
news:40b001c47308$9ff6c9e0$a301280a@.phx.gbl...
> I am using Sql server replication wizard and it create
> publisher, subscriber and Distributor successfully and
> also apply initial snapshot and transfer data. but when i
> try to synchronize manually it returns error "The process
> could not connect to subscriber "MySubscriber". i am using
> windows authentication.
|||I want to know what is that missing and what it can be.
while i try it on the same pc it is well. can u give me
help in detail
>--Original Message--
>Hi
>I think u are not on the same domain. Try to
implementing by SQL
>authentication. I have done every thing successfully. It
must be the error
>of SQL Agent. i am also working on relication these days
so i m also seeking
>any thing/error/problem related to replication. I think
u are missing some[vbcol=seagreen]
>thing during wizard.
>Regards,
>-Imran Iqbal
>"Saima" <ucoxk@.yahoo.com> wrote in message
>news:40b001c47308$9ff6c9e0$a301280a@.phx.gbl...
when i[vbcol=seagreen]
process[vbcol=seagreen]
using
>
>.
>
|||Hi,
During working i faced some strange errors and I reinslled MSDE and SQL
Server but i couldn't succed. After that i worked on freshly installed
windows 2000 Server PC and then i succeded. So you can try these things.
-Imran
"Saima" <ucoxk@.yahoo.com> wrote in message
news:40b001c47308$9ff6c9e0$a301280a@.phx.gbl...
> I am using Sql server replication wizard and it create
> publisher, subscriber and Distributor successfully and
> also apply initial snapshot and transfer data. but when i
> try to synchronize manually it returns error "The process
> could not connect to subscriber "MySubscriber". i am using
> windows authentication.

Could not connect to SQL.

When i am trying to create a new database project in VSTE DB Prof and say finish an error is thrown saying "WHEN CONNECTING TO SQL SERVER2005, THIS FAILURE MAY BE CAUSED BY THE FACT THAT UNDER THE DEFAULT SETTINGS SQL SERVER DOES NOT ALLOW REMOTE CONNECTION". I have checked all services and started all the required ones.I am also using a local connection, i am trying to connect to the database on my system.How to handel this error?

Use "Sql Server Surface Area Configuration" tool to allow Remote connection.

could not connect to server because distributor_admin is not defin

The Distributor is not available
Error 18483 coult not connect to server "VNSV20009' because
'distributor_admin' is not defined as a remote login at the server.
Here is the scenario. We have 1 SQL server that replicates to another local
reporting server, and a server on the internet. They were all working fine
before today , but now i get this error. I think it started happening when
our developer tried adding the report server as a linked server instead of a
remote server... anyone have any ideas on this one?
Thanks,
Justin
I think the developer probably dropped the remote server and then readded
it.
Your best bet is to dropped the linked server and then reenable your
subscriber. You do this through the EM menu options Tools - Replication -
Configure Publishers, Subscribers, and Distributor and then go the the
Subscribers tab and check the check box to the left of your subscriber.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Justin" <Justin@.discussions.microsoft.com> wrote in message
news:EC2EFC26-F356-4138-9BA5-08BFC6F54E28@.microsoft.com...
> The Distributor is not available
> Error 18483 coult not connect to server "VNSV20009' because
> 'distributor_admin' is not defined as a remote login at the server.
> Here is the scenario. We have 1 SQL server that replicates to another
local
> reporting server, and a server on the internet. They were all working fine
> before today , but now i get this error. I think it started happening when
> our developer tried adding the report server as a linked server instead of
a
> remote server... anyone have any ideas on this one?
> Thanks,
> Justin

Could not connect to http://localhost/Reports

Hi,
I have a problem when I try to connect to Report Server which is installed
locally. (http://localhost/Reports). When I enter this address in the
address bar, the progress bar starts to grow but the page will not be
opened. Eventually, my PC will be frozen and I will have to restart my
machine.
The installation went without any problems. SQL server 2000 is installed
locally and the OS is Windows XP SP1. What confuses me the most is that
everything was working ok, several months ago. Exactly the same behavior is
on the other PC. Report Server installed locally is not responding.
I suppose that maybe some security patch caused this strange behavior but
this is only guessing.
What might be the reason for this?
Any idea will be appreciated.
Thanks in advanced,
Mladen
--
Message posted via http://www.sqlmonster.comCheck out the Event Viewer.
Also check the log files under the LOG folder. c:\program files\SQL
Server...
Do a search for LOG...
"Mladen via SQLMonster.com" wrote:
> Hi,
> I have a problem when I try to connect to Report Server which is installed
> locally. (http://localhost/Reports). When I enter this address in the
> address bar, the progress bar starts to grow but the page will not be
> opened. Eventually, my PC will be frozen and I will have to restart my
> machine.
> The installation went without any problems. SQL server 2000 is installed
> locally and the OS is Windows XP SP1. What confuses me the most is that
> everything was working ok, several months ago. Exactly the same behavior is
> on the other PC. Report Server installed locally is not responding.
> I suppose that maybe some security patch caused this strange behavior but
> this is only guessing.
> What might be the reason for this?
> Any idea will be appreciated.
> Thanks in advanced,
> Mladen
> --
> Message posted via http://www.sqlmonster.com
>|||I have tried everything (that is why I did not answer earlier).
I have reinstalled Reporting Services using Domain Admin account and still
is not working.
I used built-in account (NTAUTHORITY\SYSTEM) for ReportServer Windows
service and xxx\ASPNET (xxx is the name of my machine where I try to
install it) for auto start service account. Since nothing was working
before, now I used domain admin account to connect to the Report server
database. Of course, it can connect to Report Server database.
There are no errors in the Reporting Services logs and the last thing that
can be seen in the log is "Polling started".
NT Event log does not contain errors as well.
This is all frustrating and I don't know what else can I do to solve this
(or where to look).
--
Message posted via http://www.sqlmonster.com|||What is more "interesting" is that my colleagues all have the same problem.
Everything was working ok some time ago but one day it stopped functioning.
--
Message posted via http://www.sqlmonster.com|||What is more "interesting" is that my colleagues all have the same problem.
Everything was working ok some time ago but one day it stopped functioning.
--
Message posted via http://www.sqlmonster.com

Could not connect to database

Hello I am new to the ASP.NET project and using Microsoft ASP.Net Web Matrix. When I try to connect to an Access Database it is no problem, but do I try to set up an connection with a SQL or MSDE database there is a problem.

It can not connect with my SQL server and gives the error:
Could not create new database.

What can be the problem. My MSSQL Server is running perfect.

Greets
Ben
HollandNeed more information. Are you using a connection string or creating a connection object in Visual Studio. Can you find your SQL Server instance in the VS Server Explorer?

Could not connect server from client machine

Hi all

I m a new member to this forum. Im a hardware engineer who rectify aome software related issues. Now our employees having problem with connecting their XP prof based clients to 2003 server from SQL query analyzer. I tried refresh sql server manager in server and tried restarting the server machine many times. sometimes it the client machine connects and disconnects immediately. i aslo tried changing the poll interval , but no use.

waiting for a speedy solutin... i know this is as easy query.

Hi mvramsubbu,

A warm welcome to forum

You need to digg more to get the Exact erro message refer Windows Event Viewer and SQL Server's Error Log for error and post them here so that you can get a good answer. unless you post the error message we can not help you.

Hemantgiri S. Goswami