Steps Before Start Developping Application That Use Sql Expr.
Mar 27, 2007
Hi All,
What are the points needed to be taken care of before starting develop an application that uses sql express as a local database. For example is there a need for an early configuration to make all end users (after the installing app from a cd to their own machines) of the application to connect to the database that I am designing. I saw many posts related to this issue but none of them describes the process step by step. So if an experienced guy/girl outlines the steps I would be delightful.
Thanks in advance.
View 8 Replies
ADVERTISEMENT
Dec 14, 2006
Dear friends,
I am working in .net windows application with sql server 2000. My problem is like some times sql server service automatically stoped when restart my machine.Then i start the service manually.after that if i restart my machine it not affect the service.I mean only at first time restart the machine make this problem. Anybody know any solution for this problerm?.
Also how can i anable TCP/IP through application.
Thanks & Regards
Jesseja
View 1 Replies
View Related
Nov 24, 2003
Hello,
I was wondering if someone could help me answer this question.
If I had a site like Yahoo, that constantly had users accessing it. Would it be a good or bad idea to automatically open a database connection to SQL Server on Application Start? What would you recommend? Would opening and closing the DB connection on every page save alot of overhead and bottleneck? Thank You.
View 2 Replies
View Related
Jul 4, 2014
Has experienced this error when trying to open SSMS? Was working fine earlier. I have tried uninstall/reinstall, a few reboots,repairing the install, etc.
View 5 Replies
View Related
Jun 12, 2015
We have an issue where servers goes slow from morning 2 AM EST to 10 AM EST.
Using SP_WhoIsActive we somehow found that there is netbackup from Symantec which runs during that time phrase.
As per Symantec team there backup should get over by 5 AM EST, per their testing for almost 100 Dbs on the server( not big in size , all of them in total would be 60 GB).
Using SP_whoisactive we only see, start time of that virtual backup occurring on tape, for one database at time.
So is there a way we actually determine when does the above backup kicks and stops?Also, could SQL server be the problem in making these backups run slow or there is something else i need to monitor?
View 6 Replies
View Related
Jul 6, 2007
Hi everybody..
I try to develope an Application with .NET C# 2.0, which uses a SQL Express Edition Database. As you know, I can give the SQL Server a password an username (or Windows auth.).
Wenn the user has already installed SQL eXpress Edition, he can access to database and change the data manual.
Is there anyway to set password to a database in SQL Server (Express)?
Thanks..
View 3 Replies
View Related
Jun 14, 2006
Hi
I have problems to find the Reporting Services in the MSSQL Server Express adv. Services. Is it because I have onlx the Windows Home installed? And the IIS is missing?
I hope not!
I also work with C# Express and now I really need to produce some reports and graphics...
Greetings from Germany,
Quattrus
View 2 Replies
View Related
Aug 24, 2007
hye everyone,
when i browse my web application the eror as below display..
what should i do..
any suggestion or tips...
"Cannot start your application. The workgroup information file is missing or opened exclusively by another user. 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.Data.OleDb.OleDbException: Cannot start your application. The workgroup information file is missing or opened exclusively by another user. "
thanks in advance..
thank you very much..
View 1 Replies
View Related
May 7, 2008
Hi all,
I'm kinda new at programming, and am currently attempting to create a web application. I have an error when I try to insert information into a sql server database, and can't find how to fix it no matter how hard I try.
The error I get is: Cannot start your application. The workgroup information file is missing or opened exclusively by another user.
I have it so a user is logged in and is shown a form to fill out, then submits it (which creates an insert statement and sends it to the database).
My connection string is as follows:
CnnString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "data source=serverdestination;" + "User id=user;" + "Password=pass;";
If you need any more information, just let me know.
Any help would be greatly appreciated!
View 2 Replies
View Related
Jun 2, 2008
Hi folks
I have a 64 bit Vista Home Premium PC SP1.
I downloaded and attempted to install the 64 bit version of SQL Express and I then got an error message to do with the ASP.NET Version registration requirement.
I then noticed a similar problem somebody else had & they solved it by doing the install/download as part of the Visual web Developer Expr installation - so I did the same. It seemed to work without any problems.
I had previously downloaded the 64 bit Management Studio Expr file, so after installing SQL server I attempted to install the management Studio program. Anyhow after starting the install program, I discovered that the instructions were either in Japanese or Chinese.
On the download page for SQL Server Express http://www.microsoft.com/express/sql/download/default.aspx, Under section 3 on the RHS it talks about Advanced Services & the Toolkit. Presumably, those downloads are for the 32 bit version, so is it possible to get a 64 bit version of Reporting Services & full-text search & the toolkit?
Anyway, if somebody could give me a bit of a clue I would really appreciate it.
Kind regards
Ross
View 4 Replies
View Related
Jun 6, 2001
Hi,
I have two job J1 and J2, each one has 10 steps. Now I want J2 to be the 11th step of J1 and I did not want manually type all the steps of J2 to be 11-20 step of J2. Is there an easy way through TSQL to do this ?
sp_add_jobstep only works when the step is OS command or a script but not a job
View 2 Replies
View Related
Mar 30, 2007
1) RS Start in Window Severvices
2) RS Start in Configration
1) and 2) Is Same?
I think that It looks like same Operation.
View 1 Replies
View Related
Jul 24, 2000
Hi,
I'm using SQL Server 7.0. I have a job which runs DTS packages (1 package per step). When a task fails within my DTS package, I'd like an error returned for that step in the job thus stopping the job and not starting up the next step (DTS package) in the job. As it stands right now, if a task fails within the DTS package, that step in the job still returns a successful completion. Has anyone seen this before and is there something I can do to get the DTS to send a failure for that step in the job?
Thanks in advance,
Darrin
View 1 Replies
View Related
Jan 12, 2007
I am going to be moving multiple databases to a new server. Everything should go smooth, but I need to change a lot of the DTS packages that reference the old servername and replace it with the databases DNS record.
Is there an easy way to get a list of which dts reference the old server explicitly (not using database DNS)?
Thanks.
View 7 Replies
View Related
Apr 13, 2008
have SQL Server 2005 std edition SP1 installed on Windows 2003 Std edition .Configured Transactional (single Publisher and no clustered environment.)
Replication past two months working fine, Now
1.Distrib.exe application err is coming.
Due to which my job is failing (Distributor to Subscriber).
Iam attaching thw file.
Thanks
Sandeep
View 1 Replies
View Related
Jun 23, 2005
hi !!!i try to connect to my sql server local instance but it is always failed ..... can you please tell me the step by steps and options to use to install sql server on my machine and i think i need to use he personal copy rather than the standard as it will be on my machne not in the server??? please help
View 6 Replies
View Related
Jun 20, 2002
Hello,
Can anybody tell me how many steps it's possible to put in one job.
The reason I ask is that we have a job that has over 500 steps (import data from Excel file into SQl table) and every time it runs we have different steps failures.
Does fact, that excel file was dropped and recreated, change DTS Id ?
Thank you in advance
View 4 Replies
View Related
Apr 27, 2001
Hi,
I am new to replication.
I have to replicate a db on SQL7.0 sp5 .
It's going to be transactionol.
Is there any article which explains everything - where to start from and where to end?
I mean everything step by step.....
TIA.
View 2 Replies
View Related
Apr 20, 2000
hello!
A job as a whole can be scheduled.But can a individual job step be scheduled?
thankfully in advance,
Rams.
View 1 Replies
View Related
Apr 27, 2006
Here is an interesting problem I can't figure out. I have a job with 6 steps as follows:
Step 1 - Import text file 1
Step 2 - Import text file 2
Step 3 - Delete all data from address tables 1 and 2
Step 4 - Copy data from imported table 1 to address table 1
Step 5 - Copy data from imported table 2 to address table 2
Step 6 - Delete imported taxt file table 1 and 2
Now when I run each of these steps individually, like running the dts packages and stored procedures my self it all works fine and the data in my tables appears to update. Then, when I set the job to run automatically, it says completed and no errors but my data hasn't updated. The job must be doing what it is meant to as it took about 40 seconds which is normal.
Ever seen this problem before?
View 1 Replies
View Related
Jul 2, 2007
Hello,
SQL Server 2005 Enterprise and new hardware have been ordered for our department. We currently run SQL Server 2000 (sp4). We have almost 500 DTS packages, 293 Jobs, and 14 user databases with hundreds of objects within.
Is there any documentation out there on how to scrutenize a current system? I have searched, and most of what I can find addresses migration planning with the assumption that the databases, packages, jobs, security, etc are ready to move over. We have a lot to think about before we can do that. We know we have redundancy problems (like View proliferation), table schema issues, obsolete DTS packages and Jobs, and otherwise a host of opportunities to 'clean house' and/or improve. We would really like to get a handle on what we are migrating before we migrate.
If you have any ideas or resources to you feel would be worth looking at, please share.
Thank you for your help!
cdun2
View 4 Replies
View Related
Mar 30, 2008
Generally speaking when you want to optimise an application that relies on a database which is the order of the following optimization techniques
a) optimizing the spread of the pysichal elements of the database on different disks of the server
b) optimizing the use ot the RAM
c) optimizing the SQL
d) opimizing the OS
Thank you,
Ronnyy
View 4 Replies
View Related
Apr 15, 2008
I've created SQL Server Agent jobs through management studio on SQL Server 2005. I can view and edit these jobs when I am logged into the server via remote desktop, but when trying to administer these jobs through Management Studio on a different machine, the steps do not appear in the job properties window.
Anybody else see this behavior? Know why it occurs? Is it a bug, or another wonderful "feature" of Manglement Studio?
View 10 Replies
View Related
Apr 22, 2008
i have setup a sql job with 4 steps
1-checkdb
2-indexdefrag
3-sp_updatestats
4-email notification.
if 1,2 success go next step
if 1,2,3 fails go step 4
if 3, 4 success quit with success
if 4 fails quit with failure
i created a script and pasted it in production server and i get this msg:
Warning: Non-existent step referenced by @on_fail_step_id.
Warning: Non-existent step referenced by @on_fail_step_id.
Warning: Non-existent step referenced by @on_fail_step_id.
how can i fix it? I think the error is due to step 4 not executing before calling it from stepe 1,2,3
View 1 Replies
View Related
Nov 14, 2007
welcome everybody
i want to publish my sql2005 server through my isa2004
so i do the following steps and i want to know if there is wrong in it or if
there is another step is missing or not?
1-i make editing in router configuration file to natting requests on my real
ip to the external interface of my isa
2-at isa i make sql publishing rule to forword requests to the ip of sql
server
(from:anywhere to: ip of sql server listner:external protocol:microsoft
sql server requests:appear from isa not original client ports:default
ports1433)
3-at sql server i enable allow remote and local connection over tcp only
4-at sql server i enable allow remote desktop
5-at sql server i enable firewall and in exception tab i add remotedesktop
and 1433 port
but still when i try to connect from internet using the studio managment
express tool using the real ip address(tcp:{my real ip address}) and login information of sql still
error occure and no connection opened....
note:scw was installed and i uninstall it
so what is the problem
why sql can't published
also i make at isa another rule to allow remote desktop to my sql server using rdp protocol but when i try to connect using remote connection to sql server it failed but when connect to any other internal server it work succesfully
View 4 Replies
View Related
May 22, 2008
I am migrating the SQL Server 2K instance from Windows 2000 server to Windows 2003 Server on a new box.
After restoring the database is there any tasks to be done to make sure the performance is not compromised.
For example... updating the statistics.....
Likewise are there any tasks that I need to run after the successful migration.
Thank you,
Gish
View 4 Replies
View Related
Dec 7, 2007
What in SSIS replaces DTS Task Steps? In DTS you could build tasks and assign them an order in which to execute. How is this replaced in the SSIS Control Flow. Thanks.
JGL
View 3 Replies
View Related
Dec 3, 2006
I am trying to create a SQL Agent job with 3 steps.
I want to delete three tables.
Step 1 ...delete table "X"
Step 2 ...delete table "X"
Step 3 ...delete table "X"
problem is that afer i create the three steps and start the job it never seems to finish the first steps and non of the other steps run, the job looks like is executing and never finishes. I break the job into three jobs each completes fine. I need this to runs one job, any ideas?
perplexed for sure.....
View 1 Replies
View Related
Sep 6, 2006
I want to update a char column and remove all the periods (.) - middle initial data. What are the basic steps in SSIS?
Source Table/Column --> Transform of some kind --> ? --> ?
I've never had to massage data and replace in the same table in my brief career so far but I see a lot more ahead.
There isn't a simple sql statement to do this, is there?
TIA
View 1 Replies
View Related
Mar 5, 2006
Hello,
Thanks for reviewing my question. I am trying to install SQL Server 2005 but I keep running into the same error:
SQL Server Setup failed to obtain system account information for the ASPNET account. To proceed, reinstall the .NET Framework, and then run SQL Server Setup again.
The only documentation I find on this is configuring the issolation mode in IIS 6.0.
Any help on is will be appreciated.
Peter
View 5 Replies
View Related
Feb 4, 2000
Hi All,
In creating 'steps' in JOBS, is it possible to execute many DOS CmdExec in
one step, instead of creating several steps with a single DOS-cmd in each.
For example:
Step1: bcp sourcedb..sourcetbl out source.dat -n -T -Ssourceserver
Step2: isql -T -Stargetserver -Q "truncate table targettbl"
Step3: bcp targetdb..targettbl in source.dat -n -T -Stargetserver
If I created a job executing those 3 functions in 3 separate steps then it works fine. But if I put all those 3 DOS command in one step, it won't work. Somehow,
SQL doesn't 'understand' it should execute after the end of each command OR
I missed something here (apparently so!).
I know if I put all those 3 DOS commands into a DOIT.BAT and execute it, it will work. But I want to use SQL Job to schedule it to run on a regular basis.
Anyone has run into this same problem? Thanks in advance.
David Nguyen.
View 1 Replies
View Related
Jun 12, 2015
My end game is to automate some of my monthly queries in a Job in SQL Server Agent. Right now I have two metric tables. One table is the name and comment with the PK. The secondary table is attributes/detail, such as reporting month, target and actuals.
I am currently running all different types of queries to get the aggregates. I'd like to get these into a job so it would run automatically and update the reporting table.
Would you recommend making one step or multiple steps for each query? I am trying to use an intelligent approach to begin to load the tables.
View 2 Replies
View Related
Dec 22, 2006
Hi all,
Can any one help me in this issue?I am new for this SQL server.By creating scripts from server system.I got the tables without data in my system.But i want to get the full database as usual there in server.
I have to convert my existing MS Access frontend and SQL backend app into ASP.NET web app with sql server backend.The version is 2000.Pls it's urgent?
Kranthi
View 2 Replies
View Related
