Can I have SQL server clear a value after a certain amount of time?

I have an application that allows users to "reserve" a certain time and location for practice sessions. I want them to look at a web form that shows which times are available and then allows them to select an open slot and then submit this form with some personal information. My problem is that as soon as they select an open slot, other users should see that this slot is no longer available. On the other hand, if someone selects an open slot and then takes too long to type in their personal information, I want it somehow to kick them out and re-open this slot back up.

I know that I can create a field called 'status' in my database that gets turn to something like 'pending' as soon as the first user clicks on an open slot, but how would I turn this field back to the 'open' state if the user took too long to enter their data?

Any help would be surely appreciated.

Cheers,
AzFyou can store the time the page was requsted in some variable and check against some preset time like 5 min or 10 min...also when do you set the slot as reserved...as soon as the user clicks on the spot or at the end of the page after the user finished entering all the info...? i would suggest doing the latter...

hth

Can I Have Link Between Several servers

hello all

I have a web application(asp.net) and Database(sql server 2005) .

we have installed them on several servers.

now we want to have a connection between apllication on one server to a database on another server .

for example we have Server(A) and Server(B) the DataBases and Web apllications on two server are the same.

sometimes the Apllication on server(A) must connect to database on server(B).

whats the solution plz?

note that the number of servers can be inceased in the future this mean the number of servers are not fixed.

thanks

Use the function sp_linkedServer of the SQL to link the borh servers.

helped?

Regards

Can I Have link Between Several Servers

hello all

I have a web application(asp.net) and Database(sql server 2005) .

we have installed them on several servers.

now we want to have a connection between apllication on one server to a database on another server .

for example we have Server(A) and Server(B) the DataBases and Web apllications on two server are the same.

sometimes the Apllication on server(A) must connect to database on server(B).

whats the solution plz?

note that the number of servers can be inceased in the future this mean the number of servers are not fixed.

thanks

Not sure I follow -- do you mean you have 2 different database serves that should mirror each other, ie, the data is the same and updates on one should be mirrored on the other?

|||

You have a database in the server A .. connect to it by using ConnectionStringA , and any need data from Server B .. use another ConnectionString (e.g. ConnectionStringB).

So, in the web.config file you will have tow ConnectionStrings (A & B).. when to connect to the database in the same server use StringConnectionA and the other used to connect to the database in the another server (server B) - called ConnectionString B.

Good luck.

|||

thank you

for Contributor : i have defrerent data in each databas i cant use replication

for Participant : i must connect to different web server .

i get it that i must to use splinkserver to link servers

thanks forever.

Can I get a Query from a Fetch_cursor in SQL2000

Hi, The main application we used uses prepared cursors when running statments against the database. This makes it very hard to debug the querys as if you get an error or lock on the database all you can see is the Fetch_curror statement and the number of the statment. If you know the lock is coming that's fine as you can run up the profiler but if you don't know it will happen then the profiler doesn't help as the cursor has already been prepared.

Is there a way of using the cursor number to query the SQL engine and find out what statment was prepared?

If your app is doing server side cursors and names them then you may be able to use sp_cursorlist, sp_describe_cursor_tables and sp_describe_cursor_columns to better understand what the query is doing. Then you can query the sysCacheObjects table in the master database and it will show you the first 128 characters of the batch (on 2005 it will show you the first 3900 characters) of cached plans. You can use the ObjType column to distinguish between ad-hoc, prepared, stored procedures etc.

See BOL for more info.

|||

Thanks fro the reply David but it still doesn't give me the query that was run (the TSQL), if all I had was the fetch_cursor id.

The sysCacheObjects is cool, I can use this for other things:)

|||True, you can't query the sysCacheObjects table just based on the cursor_id but I thought it would be the next best thing, since it gives you a place to look for cached plans and the queries that sparked them.|||

It is not possible to get the query with just the cursor handle in SQL Server 2000. You could query syscacheobjects if you know the prepare cursor call or a part of the SELECT statement etc. You will have to rely on SQL Profiler or application trace to get the calls.

In SQL Server 2005, you can use the new dynamic management function sys.dm_exec_cursors to better determine cursor handles on the server, their associated sql handles to get query text and other information.

sql

Can I get a link to step-by-step MSDE install instrustions on WIN2

Hi All,
I new when it comes to MSDE but all I need to do is install it and setup an
ODBC data source for an application I run. It's on Windows 2003 Server and no
matter what I do I can't setup an ODBC connection using SQL authentication
because I get error 18456 all the time. I've granted my windows account login
access, the install is NOT set for windows authentication only, and TCP/IP is
enabled. I can login as sa from the command line but not through the ODBC
manager. I'm on about my 5th reinstall and have become very frustrated here.
Can some one point me in the right direction please?
Thanks
That error is a login failure, it surely doesn't help reinstalling. You need
permission to log into your SQL Server.
If you are member of the local administrators group, you shouldn't get this
error.
Other possibilities could be if you have semi-colon in your username (there
is a KB article on this).
Please use your full name when posting to these newsgroups.
Jon Jahren
"ComfortablySAD" <ComfortablySAD@.discussions.microsoft.com> wrote in message
news:D5C5E09E-BEE4-4BC9-A2E4-4E1BAEFB67BB@.microsoft.com...
> Hi All,
> I new when it comes to MSDE but all I need to do is install it and setup
an
> ODBC data source for an application I run. It's on Windows 2003 Server and
no
> matter what I do I can't setup an ODBC connection using SQL authentication
> because I get error 18456 all the time. I've granted my windows account
login
> access, the install is NOT set for windows authentication only, and TCP/IP
is
> enabled. I can login as sa from the command line but not through the ODBC
> manager. I'm on about my 5th reinstall and have become very frustrated
here.
> Can some one point me in the right direction please?
> Thanks

Can I Force SQL to Accept INSERT List of Values Less Than Number of Columns?

I have a canned application that does INSERTs with lists of values without
column lists. The table has one additional (uniqueidentifier) column for merge
replication, so the application is inserting 7 values, but there are 8
columns. Is there a way to tell SQL to accept it anyway and just fill the
columns from left to right until it runs out of data? I hope so, because I
have no access to the source code.
--EricHello Eric. you could try with renaming that table (the one you insert in)
and creating a view with old name of the table you just renamed. In the view
definition specify all fields from the renamed table except the one that you
added for replication(uniqueidentifier) .
Hope this works,
Regards,
Tomislav Kralj
tomislav.kralj1@.zg.tel.hr
"Eric Robinson" <eric@._nospam_nvipa.com> wrote in message
news:CFN379450577312037@.news.microsoft.com...
> I have a canned application that does INSERTs with lists of values without
> column lists. The table has one additional (uniqueidentifier) column for
merge
> replication, so the application is inserting 7 values, but there are 8
> columns. Is there a way to tell SQL to accept it anyway and just fill the
> columns from left to right until it runs out of data? I hope so, because I
> have no access to the source code.
> --Eric
>|||If there isn't a column list specified in the INSERT then the number of
columns in the table must match the number of columns in the INSERT
statement (less the IDENTITY column, if any).
You could set a default for the uniqueidentifier column, rename the table
and then create a view under the original name containing all except the
extra column:
CREATE TABLE newname (a INTEGER PRIMARY KEY, b INTEGER NOT NULL, c
UNIQUEIDENTIFIER NOT NULL DEFAULT NEWID() ...)
CREATE VIEW oldname
AS
SELECT a,b
FROM newname
Then find the programmer and make him fix his code.
--
David Portas
--
Please reply only to the newsgroup
--|||"Tomislav Kralj" <tomislav.kralj1@.zg.tel.hr> wrote in message
news:bpi4j6$vq0$1@.sunce.iskon.hr...
> Hello Eric. you could try with renaming that table (the one you insert in)
> and creating a view with old name of the table you just renamed. In the
view
> definition specify all fields from the renamed table except the one that
you
> added for replication(uniqueidentifier) .
Oh, and i forgot. create view with VIEW_METADATA option !!!
Regards,
Tomislav Kralj
tomislav.kralj1@.zg.tel.hrsql

Can I force a checkpoint.

Our application is having problems due to what appears to be a flush to disk
during a checkpoint. The flush lasts 2-6 seconds and then every thing
continues on as before with no delay.
I tried creating a job to run every two minutes (just during our stress test).
All the job does is call "CHECKPOINT". Looking at the logs during my stress
tests, there is no difference in the behavior.
So, how can I get the DB to do checkpoints more often to prevent such a
large lump write ?
Or, am I totally off in the wrong direction on this ?
Any thoughts would be greatly appreciated.
Mark.
Notes: all databases are running in simple mode.I am looking at checkpoint pages/sec and pages writes/sec along with
physical read and write.
Also, I am monitoring the log %used on all DB's. I can see that when one of
my DB's hits
70% it appears to be related to this dump which seems to go along with the
docs for
checkpoint and db set to simple.
I am 100% sure it is not related to a query. It might not have anything to
do with a checkpoint,
but when the log file grows to 70% and gets reset to 20% I can see this huge
write and
I get a major backup. I see a similar relation on another DB.
Should I just shrink the log file, will this help decrease the number of
pages to write?
It appears to be true on a different DB with a smaller log file the writes
following
the truncation of the log is very small in comparison, does that make sense?
Thanks,
"Brian Moran" <brian@.solidqualitylearning.com> wrote in message
news:Oz3lJpYUDHA.484@.TK2MSFTNGP09.phx.gbl...
> how do you know for sure it's related to checkpoint? What counters are you
> basing that on? CHECKPOINT will run the checkpoint process so I'm not
really
> sure what you'e asking... you can run it as frequently as you want...
> also... I might take a look at SQL Profiler to see if there is some other
> query that is perhaps related to the IO... it might not be checkpoint
> related...
> --
> Brian Moran
> Principal Mentor
> Solid Quality Learning
> SQL Server MVP
> http://www.solidqualitylearning.com
>
> "Mark DeBusschere" <developer@.line-4.com> wrote in message
> news:uTEjGgXUDHA.1552@.TK2MSFTNGP10.phx.gbl...
> > Our application is having problems due to what appears to be a flush to
> disk
> > during a checkpoint. The flush lasts 2-6 seconds and then every thing
> > continues on as before with no delay.
> >
> > I tried creating a job to run every two minutes (just during our stress
> test).
> > All the job does is call "CHECKPOINT". Looking at the logs during my
> stress
> > tests, there is no difference in the behavior.
> >
> > So, how can I get the DB to do checkpoints more often to prevent such a
> > large lump write ?
> >
> > Or, am I totally off in the wrong direction on this ?
> >
> > Any thoughts would be greatly appreciated.
> >
> > Mark.
> >
> > Notes: all databases are running in simple mode.
> >
> >
>|||Hi Mark,
My name is Michael and I would like to thank you for using Microsoft VAP
newsgroup.
I will update you later. In the mean time, if you have any other useful
information, please feel free to let me know.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Can i developmy db in SQL Server MSDE then upload to SQL Server 20

I want to develop a web application using the MSDE version of SQL server -
will i then be able to upload it to a web host running SQL Server 2000?
Thanks
Yes.
"JoeConnor79" <JoeConnor79@.discussions.microsoft.com> wrote in message
news:8F42A758-7C69-4A04-94A7-5A7F1A0A709A@.microsoft.com...
> I want to develop a web application using the MSDE version of SQL server -
> will i then be able to upload it to a web host running SQL Server 2000?
> Thanks

Can I deploy a runtime version

Is is possible to deploy MSDE with a database in such a way that an end user
can only access that database via a custom application? In other words, I
don't want the end user to be able to use osql (or any other tool) to get
into the database, and I don't want them to be able to detach that database
and attach it to a full blown SQL Server.
Thanks.
No, it is not possible. If the user has full right (Admin right) to his
computer, he can do anything to SQL Server/MSDE on this computer:
attaching/detaching it, peeking into the database structure. The most you
can do is to encrypt the data content, if you can find a reliable tool to do
that.
"Tom Iarusso" <TomIarusso@.discussions.microsoft.com> wrote in message
news:E2A8F5F9-A707-4985-8E00-C419353C82D9@.microsoft.com...
> Is is possible to deploy MSDE with a database in such a way that an end
> user
> can only access that database via a custom application? In other words, I
> don't want the end user to be able to use osql (or any other tool) to get
> into the database, and I don't want them to be able to detach that
> database
> and attach it to a full blown SQL Server.
> Thanks.

Can I Deploy a report to a client who doesn't have SQL server license.

How can I Deploy a report with my visual Studio.Net application to a company
who doesn't have SQL server license?
I plan to use SQL Server 2005 Express.SQL Server Express does not yet have support for this. Supposedly Q1. Then
the data needs to reside locally as well.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Roberto Hernández" <robertohh@.newsgroups.nospam> wrote in message
news:%23uQARosIGHA.1760@.TK2MSFTNGP10.phx.gbl...
> How can I Deploy a report with my visual Studio.Net application to a
> company who doesn't have SQL server license?
> I plan to use SQL Server 2005 Express.
>|||VS2005 provide a report viewer control which allow you to render reports.
does your application is web or windows based?
"Roberto Hernández" <robertohh@.newsgroups.nospam> wrote in message
news:%23uQARosIGHA.1760@.TK2MSFTNGP10.phx.gbl...
> How can I Deploy a report with my visual Studio.Net application to a
> company who doesn't have SQL server license?
> I plan to use SQL Server 2005 Express.
>|||Hi Roberto,
As Bruce mentioned, the SQL Server reporting service is not available for
EXPRESS edition so far. Also, what's your application's detailed structure,
does it require a local SQL Server instance? If it is just a client
application which can consume reporting service reports through those
remote accessible programming interfaces, we can consider separate the
application from the backend SQL Server database... Thus, there need a
certain DataBase server which have SQL Server 2005 instance installed
already...
Regards,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
| From: "Jéj? <willgart@.BBBhotmailAAA.com>
| References: <#uQARosIGHA.1760@.TK2MSFTNGP10.phx.gbl>
| Subject: Re: Can I Deploy a report to a client who doesn't have SQL
server license.
| Date: Thu, 26 Jan 2006 21:35:45 -0500
| Lines: 12
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| X-RFC2646: Format=Flowed; Response
| Message-ID: <emzDhpuIGHA.424@.TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: modemcable008.41-80-70.mc.videotron.ca 70.80.41.8
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67651
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| VS2005 provide a report viewer control which allow you to render reports.
| does your application is web or windows based?
|
| "Roberto Hernández" <robertohh@.newsgroups.nospam> wrote in message
| news:%23uQARosIGHA.1760@.TK2MSFTNGP10.phx.gbl...
| > How can I Deploy a report with my visual Studio.Net application to a
| > company who doesn't have SQL server license?
| >
| > I plan to use SQL Server 2005 Express.
| >
|
|
||||RDLC reports doesn't required any server.
its standalone reports generated on the client side, not the server side.
Also, I think that the report control can render RDL reports without using a
reportserver.
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:TUqDfawIGHA.1236@.TK2MSFTNGXA02.phx.gbl...
> Hi Roberto,
> As Bruce mentioned, the SQL Server reporting service is not available for
> EXPRESS edition so far. Also, what's your application's detailed
> structure,
> does it require a local SQL Server instance? If it is just a client
> application which can consume reporting service reports through those
> remote accessible programming interfaces, we can consider separate the
> application from the backend SQL Server database... Thus, there need a
> certain DataBase server which have SQL Server 2005 instance installed
> already...
> Regards,
> Steven Cheng
> Microsoft Online Support
> Get Secure! www.microsoft.com/security
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
>
> --
> | From: "Jéj? <willgart@.BBBhotmailAAA.com>
> | References: <#uQARosIGHA.1760@.TK2MSFTNGP10.phx.gbl>
> | Subject: Re: Can I Deploy a report to a client who doesn't have SQL
> server license.
> | Date: Thu, 26 Jan 2006 21:35:45 -0500
> | Lines: 12
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
> | X-RFC2646: Format=Flowed; Response
> | Message-ID: <emzDhpuIGHA.424@.TK2MSFTNGP12.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: modemcable008.41-80-70.mc.videotron.ca 70.80.41.8
> | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
> | Xref: TK2MSFTNGXA02.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:67651
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | VS2005 provide a report viewer control which allow you to render
> reports.
> | does your application is web or windows based?
> |
> | "Roberto Hernández" <robertohh@.newsgroups.nospam> wrote in message
> | news:%23uQARosIGHA.1760@.TK2MSFTNGP10.phx.gbl...
> | > How can I Deploy a report with my visual Studio.Net application to a
> | > company who doesn't have SQL server license?
> | >
> | > I plan to use SQL Server 2005 Express.
> | >
> |
> |
> |
>

Can i create reports using VB Express and SQL Server Express?

Hi,

i ve installed visual basic express and sql server express. my question is can i create reports in my database application?

An update for SQL Server Express that includes a limited edition of Report Server is expected to become available in 2006. Its features are described here: http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx

-- Robert

Can I Copy Structure from One Location (server) to Another (server)

hi all,

i am develpoing an application, and using SQL 2000. i have some of the client. and my devloping as well as the database modifiction is under construction... and now i want to copy the newly added feature such as new table, view as well as some new columns of existing table.. etc.. to Client server..

is there any easier way to copy structure to client side without affecting its data.

Tejas Kishanwala

Easier way ? the answer is NO.......... In such scenario , if u have a systamatic method then it is very easier to handle multiple development server. Before applying any change to master Developemnt server u create a script for the particular modification and apply that in master and distribute the script to others also. Otherwise there are third party tool available for it. u can try that.

Madhu

|||Hi,
thanx for reply.

pls. give me the name of some of the third party tool............

Tejas|||

check this site: http://www.red-gate.com/

also google for free sql tools

Madhu

|||

Be aware that also the visual Studio for Database professional has a funcationality to do this. You can compare two database for schema or data differences and create alter / update scripts to change the target database and to keep them in sync. As the tool is integrated within visual Studio and it has some other interesting features for development I would suggest you to check this out.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Can I change a datasource's properties at report execution time?

I will be running reports on a shared database server. The database server
supports one main application with many environments for different user
groups. Each groupsâ' data is kept in a different database instance.
I want to deploy my reports in a single location on the shared database
server to simplify installing reporting services and deploying reports.
When a user requests a on-demand report I want the report to pull the data
from the correct SQL Server instance.
Can I to change the reportâ's shared datasource â'Connection Stringâ' to the
userâ's database instance. I will be using SOAP to invoke the reports.
Are there other ways to accomplish my intentions?
I am using SQL Server 2000 Reporting Services Developer Edition with SP1 and
SQL Server 2000 Standard Edition with service packs 1, 2, 3, and 3a applied.Hi,
You may want to use 'SetReportDataSources' to switch between datasources.
More information about this method can be found from the MSDN site:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/
rsp_prog_soapapi_intro_0dnq.asp
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: Can I change a datasource's properties at report execution
time?
>thread-index: AcUz8ztCgxbpG2rJQdCyH/tlSmdIXw==>X-WBNR-Posting-Host: 192.85.47.1
>From: =?Utf-8?B?dGV4YXMzNDYw?= <texas3460@.noemail.nospam>
>Subject: Can I change a datasource's properties at report execution time?
>Date: Mon, 28 Mar 2005 16:07:01 -0800
>Lines: 17
>Message-ID: <26693252-7562-4848-9FD1-9D529F3D40F9@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 8bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>Path: TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.reportingsvcs:46323
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>I will be running reports on a shared database server. The database
server
>supports one main application with many environments for different user
>groups. Each groupsâ' data is kept in a different database instance.
>I want to deploy my reports in a single location on the shared database
>server to simplify installing reporting services and deploying reports.
>When a user requests a on-demand report I want the report to pull the data
>from the correct SQL Server instance.
>Can I to change the reportâ's shared datasource â'Connection Stringâ'
to the
>userâ's database instance. I will be using SOAP to invoke the reports.
>Are there other ways to accomplish my intentions?
>I am using SQL Server 2000 Reporting Services Developer Edition with SP1
and
>SQL Server 2000 Standard Edition with service packs 1, 2, 3, and 3a
applied.
>

Can i access SQL Login Users in ASP.Net application

Hello All,

I have SQL Server 2005 Installed and i have numbers of SQL Logins users which i want to use in my ASP.Net Application for authentication.

I am using ASP.Net 2.0 (VS.Net 2005).

Can i use the SQL Logins for ASP.Net web application authentication like the way we use Active Directory users?
Thanks in advance,
Wajahat Abbas
http://www.wajahatabbas.com

SQL Authentication is specific to SQL. You will not be able to use SQL Logins as you use Windows users.

See also:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconaspnetauthentication.asp

Thanks
Laurentiu

|||

Thanks for replying.

Ya, i was thinking that with SQL 2005 and ASP.Net release, MS will increase the ASP.Net authenticaiton modes.

As SQL Server 2005 provides very cool features for SQL Users (like bad password, rating), so once we able to consume those things in ASP.Net it would be a peice of cake.
Anyway may be in next releases.

Thanks & Regards,
Wajahat Abbas
http://www.wajahatabbas.com
http://www.dotnetpakistan.com

Can i access SQL Login Users in ASP.Net application

Hello All,

I have SQL Server 2005 Installed and i have numbers of SQL Logins users which i want to use in my ASP.Net Application for authentication.

I am using ASP.Net 2.0 (VS.Net 2005).

Can i use the SQL Logins for ASP.Net web application authentication like the way we use Active Directory users?
Thanks in advance,
Wajahat Abbas
http://www.wajahatabbas.com

SQL Authentication is specific to SQL. You will not be able to use SQL Logins as you use Windows users.

See also:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconaspnetauthentication.asp

Thanks
Laurentiu

|||

Thanks for replying.

Ya, i was thinking that with SQL 2005 and ASP.Net release, MS will increase the ASP.Net authenticaiton modes.

As SQL Server 2005 provides very cool features for SQL Users (like bad password, rating), so once we able to consume those things in ASP.Net it would be a peice of cake.
Anyway may be in next releases.

Thanks & Regards,
Wajahat Abbas
http://www.wajahatabbas.com
http://www.dotnetpakistan.com

Can I access sql 2000 from machine having sql2005

Dear All,

I am developing a network application in asp.net. The database is in local machine having sql 2005. But the user database is already existent. So I am accessing that database which is sql2000. does it give any problem while connecting from sql2005 machine to sql2000. If yes it is giving me error as follows:

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: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)

connection string is :

"Data Source=192.168.1.16,1433;Network Library=DBMSSOCN;Initial Catalog=mycatalog;User ID=myuserid;Password=mypwd;"

Please correct me if I am wrong.

Thanks and Regards.

Fazal

This indicates that your TCP/IP was not enabled or your sql server was not listening on the appropriate port.

|||

Go to "Microsoft SQL Server 2005" in programm files => onfiguration Tools =>SQL Server Surface Area Configuration =>first option=>Remote Connections

and here allow remote connection = Use both TCP/IP and name pipes => OK

After that you must restart SQL Server 2005 in order to apply the modification and try againa

Popa IUlia

_____________________

MCP.MCAD.MCSD

Can I access MSDE on a remote machine with Enterprise Manager?

We just installed an application, WhatsUpGold, to monitor our servers. Management won't let me host that on my primary SQL box. So, we are using MSDE on the local machine (call that box my_netmon).

I can access the db with very basic functionality using osql while on the my_netmon machine. I've added my domain user account as a System Admin using the following commands.

exec sp_grantlogin @.name
go

exec sp_addsrvrolemember @.name, 'sysadmin'

But when I go to the my_sql machine and try to attach to it with Enterprise Manager I get an error that the server does not exist.

What gives? Is it just not possible, or am I missing something here?

My goal is to just be able to see the data stored in the MSDE db. Write views, etc...

Please advise,

MarcHas anybody accessed MSDE from a remote machine. Or can it only be access locally with ODBC type connections?|||yes, you can use MSDE remotely. what does your connection string look like? is it a named instance?

for that matter, why bother with MSDE? it's ancient. you should use SQL Server Express if this is for new development.

Can Flash work with SQL 2005 for non-web application?

I am not sure if this is the right folder to post, but currently I'm considering using Flash as an interface, the application at www.mobik.com seems impressive, simple and sweet. But I'm wondering if I can build desktop application with flash and SQL2005 as backend for all the processing. at the same time, the flash shall be getting updates from a server. Possible?I would think so. I have never written anything in flash but there must be apis for it to communicate to the outside world. How else would all those flash games be able to save their high scores? :)

if you can use COM or .net from inside flash then you could certainly do it.|||wouldn't that make the whole thing very messy?

I'm trying to reduce different technologies/platform to be used within a single application..... if not because .net 3.0 is also not impressive enough, I wouldn't have look at flash......

I think there is not many people doing it. But I heard Crystal Excelsiors is Flash base.|||again, I have no experience with Flash, so I should probably shut up. :)

what I do have experience with is the standard apis that clients use to communicate with SqlServer. Those are things like SqlClient (.net), OLEDB (com), etc.

I'd be surprised if Macromedia had their own api for talking to databases however. I bet they just tell people to use existing apis. just a guess.

If I were you I wouldn't use flash to build a non-web GUI client though. I'd use winforms and C#.|||winforms is not user friendly enough, my users has no keyboard, everything is accessed through touch panel. I guess it is easier to achieve "WOW" UI with Flash, do correct me if I'm wrong :)

Can connect in VB but not VBA!

Hello,
We are experiencing a frustrating problem where we can connect to an interna
l
SQL Server via any application EXCEPT Office apps (Excel, Word, etc.) using
VBA. The error is:
[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or a
ccess
denied.
We're using very elementary code, that succeeds in VB programs, for example,
but fails in Excel VBA. The code is:
on error resume next
Dim conn As ADODB.Connection
Dim strw As String
Set conn = New ADODB.Connection
strw = "Provider=sqloledb;User ID=the_user;Password=the_password;" & _
"Data Source=192.168.0.8;Initial Catalog=the_catalog;Network
Library=DBMSSOCN;"
' errors out here
conn.Open strw
If Err.Number = 0 Then
MsgBox "seems alright."
Else
MsgBox "error: " & Err.Description
End If
conn.close
set conn = nothing
We're stumped. We've never heard of any ADODB VB code, that works perfectly
fine in a VB application, that suddenly stops working when ported to Excel
VBA. We've tried specifying the port, changing the Network Library, etc., as
well...all sorts of things.
Help!I would guess there is still some difference some way in how
you are connecting in VB apps and how you are connecting in
VBA - especially if you always connect fine from VB to the
same server from the same PC and using the exact same code
in VBA to the same server from the same PC does not work.
And of course this would imply that the VB app and the VBA
app have the exact same references in the exact same order.
It's doesn't sound like it's really a SQL Server issue but
you could investigate the possibilities listed in this
article:
Potential causes of the "SQL Server does not exist or access
denied" error message
http://support.microsoft.com/?id=328306
-Sue
On Thu, 07 Sep 2006 05:30:26 GMT, "brianUE" <u26284@.uwe>
wrote:

>Hello,
>We are experiencing a frustrating problem where we can connect to an intern
al
>SQL Server via any application EXCEPT Office apps (Excel, Word, etc.) using
>VBA. The error is:
> [DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist
or access
>denied.
>We're using very elementary code, that succeeds in VB programs, for example
,
>but fails in Excel VBA. The code is:
> on error resume next
> Dim conn As ADODB.Connection
> Dim strw As String
> Set conn = New ADODB.Connection
> strw = "Provider=sqloledb;User ID=the_user;Password=the_password;" & _
> "Data Source=192.168.0.8;Initial Catalog=the_catalog;Network
>Library=DBMSSOCN;"
> ' errors out here
> conn.Open strw
> If Err.Number = 0 Then
> MsgBox "seems alright."
> Else
> MsgBox "error: " & Err.Description
> End If
> conn.close
> set conn = nothing
> We're stumped. We've never heard of any ADODB VB code, that works perfect
ly
>fine in a VB application, that suddenly stops working when ported to Excel
>VBA. We've tried specifying the port, changing the Network Library, etc., a
s
>well...all sorts of things.
>Help!

Can an ASP.NET application running on WinXP+IIS5 access to SSRS web service?

Hi,
I am developing a web application on windows XP. A page within my
application needs to access to SSRS running on the same machine. Once the
web application tries to consume the SSRS web services, I receive the
following error:
System.Web.Services.Protocols.SoapException: The permissions granted to user
DEV1\ASPNET' are insufficient for performing this operation. -->
Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The
permissions granted to user 'ALISGD\ASPNET' are insufficient for performing
this operation.
The user DEV1\ASPNET is member of
"SQLServer2005ReportingServicesWebServiceUser$DEV1" local NT groups. Also I
added the user "DEV1\ASPNET" to browsers and also "System Administrator"
role within SSRS web portal. still the same problem.
I do have the following code on my web service proxy code:
reportingService.UseDefaultCredentials = true;
Obviously I can solve the problem by using this code:
System.Net.ICredentials netCredential = new
System.Net.NetworkCredential("Username","Password","Domain");
reportingService.Credentials = netCredential;
But I like to find the root of the problem and solve it properly.
Is there any way that a web application running on IIS5+XP as user "ASPNET'
access to SSRS web service?
Any help would be appreciated,
MaxHello Max,
Please check the following settings:
1. Make sure the ASPNET account is under the RSExec Role in MASTER, MSDB,
ReportServer, ReportTempDB database.
2. Go to Local Policy. For "Act as part of Operating System", added ASPNET
and SYSTEM. For "Impersonate a client after authentication", added SYSTEM.
3. Restarted IIS and RS.
Hope this helps.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei,
I have users who don't have "Act as part of Operating System", and they can
work with SSRS web services.
"Act as part of Operating System" works, but I expect there is less
previlage setting for ASPNET user that can intercat with SSRS.
Kind Regards,
Max
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:NR0QuNn0HHA.4844@.TK2MSFTNGHUB02.phx.gbl...
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hello Max,
I would like to know what permission your other user have.
If you don't grant the "Act as part of Operating System", did this issue
appeared?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.