.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

Challenges in Starting with SQL Server, databases and SQL

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server
 

What do you find most difficult?

o Installing SQL Server

o Installing the sample databases

o Using Management Studio

o SQL queries

 


Kalman Toth, SQL Server & Business Intelligence Training; SQL Server 2008 Training


View Complete Post


More Related Resource Links

Linq with two databases (oracle and sql server)

  

Hey,
i have a problem to bring the data from the oracle (external database) and the sql server together (with similar data). The linq entities are linked to each other. The structure is like different countries with different cities and so on. To display these "non original linq objects" i need to put them into entities (linked to each other). Now i add some of them to my sql database. But for every entity i must check the connection to the other objects i don't want to add and delete them (otherwise linq will add all the connected objects, even those I don't want to add). If this goes wrong the whole input-method crashes. Is there any other possibility, except from checking every single entity and removing unwanted connections, to handle this procedure?
Thanks a lot, preg


Error starting SQL Server Agent - Could not load the DLL xpstar90.dll. Reason: 126

  
AD Service account password was changed.  Now the SQL Server Agent (MSSQLSERVER) will not start even after updating the password.  Have no access into the databases.  Log files say "Could not load the DLL xpstar90.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.)."  Service Account has Full rights on system.  Any help in solving the problem would be great.

Joining tables from 2 SQL Server CE databases

  
Is it possible to join 2 or more tables in different SQL Server CE databases? I am currently using VB.NET 2008 and SQL Server CE 3.5.

Failed to generate a user instance of SQL Server due to failure in starting the Process for the User

  
Could someone help with this please? I'm using VWD 2010 to build a new web site - I tried to add a new database file but it won't do it. I started by clicking on the folder 'App_Data', then right clicking and selecting 'Add new item' - after that I tried to add an SQL Server Database but received this message...  'Failed to generate a user instance of SQL Server due to failure in starting the Process for the User Instance' What does this mean? How do I start the 'Process for the User Instance'?  I imagined all that was done for me at the install stage, when I installed VWD2010, but it appears not.  Thank you for any help at all.    Regards

(SQL Server 2008) Exporting entire databases to SQL CREATE/INSERT statements

  
Hi All, I'm looking for a way to export SQL Server 2008 (Express or otherwise) databases to CREATE/INSERT statements.  I've seen a million threads (give or take) with instructions for creating large (often illegible) TSQL scripts for the task.  However, I'm hoping that this isn't the only way by which to do it.  I have need to regularly back up the data from existing MS SQL Server DBs (which are used by some of our standard apps) to various other MySQL and PostgreSQL databases (which are used by PHP and Rails web front ends).  I need to export them from MS SQL Server 2008 to a general format (i.e. INSERT statements) and perform regex edits on the file as necessary. FYI, I've written a few applications that connect to the various DBs over ODBC, etc. and transfer the data row by row.  You can image how painful this process is... I realize that there are many tools that do this.  However, most of them approach the issue from the standpoint of migration, and not that of regularly scheduled backups.  Also, this tool will need to eventually be distributed so having to purchase a license for the migration app for each person/group simply isn't feasible. Anyway, if you guys have a quality, straightforward solution to this issue, it would certainly be appreciated. Best.

need help moving System Center SQL Databases to new SQL Server about30 databases to be moved...

  
We are running various System Center products, SCSM, SCVMM, SCCM, DPM, OPALIS. and a few other servers all using the same SQL server, which currently is a VM. We have configured and built a new Physical box that will replace this. In the past we have moved SQL databases by doing a full backup and then restoring the backup on the new server, then renaming the servers, both network name and internal sql name.  This has worked fine in the past. However I've never had to move 30 databases before, nor have I had to move reporting services. Is there a better method. a recomended method? 

Problem in starting the SQL Server Reporting Services

  
Hi All,   I have a problem in deploying the reports. when i try to deploy the reports it shows that  Report Sever not working but when i try to start my SQL Server Reporting Services will get the below mentioned error so please can one could suggest me on  this. "Could not Start the SQL Server Reporting Services (MSSQLSERVER) service on local computer ERROR1053: Service didnt respond to start or control request in a timely fashion" Regards, Snusha  

SQL Server not starting - FallBack certificate initialization failed

  
I can not start my SqlServer 2008 Express. The problem seemed to start when I changed my "Built In account, Log in as" from Local Service to Local System. If I try to change back to Local Service I get the messagebox with WMI Provider Error, "Cannot find object or property. [0x80092004]". Getting a bit confused, but read http://support.microsoft.com/kb/900497    mentioned about  HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib, Value name: Certificate, Type: REG_SZ not having a valid value then 2005 would not starte - my value is blank. Changing it to 0 did not work.How can I import a valid certificate using SQL Server Configuration Manager. And how do you turn off Forced Encryption? Not sure if this would fix it, but couldn't hurt.====================================== 2009-03-08 01:39:06.01 Server      Error: 17190, Severity: 16, State: 1.2009-03-08 01:39:06.01 Server      FallBack certificate initialization failed with error code: 1.2009-03-08 01:39:06.01 Server      Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.2009-03-08 01:39:06.01 Server      Error: 17182, Severity: 16, State: 1.2009-03-08 01:39:06.01 Server      TDSSNIClient initialization failed with error 0x80092004, status code 0x80. Reason: Unable to i

Run Reporting services 2005 with databases housed on SQL Server 2008?

  
Hi, I have a RS 2005 install in which the ReportServer and ReportServerTempDB databases reside on a different SQL Server 2005 server. I am planning to upgrade both to 2008 at some point but would like to do the SQL database engine first. So I would be running something like this: Server A: SQL 2005 Reporting Services Server B: SQL 2008 database engine - housing ReportServer and ReportServerTempDB Is this configuration supported? If I do this would I just need to run the DB's in 9.0 compatibility mode until we upgrade the RS server? Would it be better to upgrade the RS box first or both of them at the same time instead of doing the database engine first?

Run Reporting services 2005 with databases housed on SQL Server 2008?

  
Hi, I posted this in the RS forum as well but was thinking it would be better here. I'm not sure if I can move a post to  a different forum or not so sorry for the double post. I have a RS 2005 install in which the ReportServer and ReportServerTempDB databases reside on a different SQL Server 2005 server. I am planning to upgrade both to 2008 at some point but would like to do the SQL database engine first. So I would be running something like this: Server A: SQL 2005 Reporting Services Server B: SQL 2008 database engine - housing ReportServer and ReportServerTempDB Is this configuration supported? If I do this would I just need to run the DB's in 9.0 compatibility mode until we upgrade the RS server? Would it be better to upgrade the RS box first or both of them at the same time instead of doing the database engine first?

SQL Server Security > Logins vs. Databases > Security > Users

  
Why isn't all security needs done just in logins?  When migrating databases, the Logins are not brought over when restoring a backup.  It does not make sense.  Could it not be done all just in the Security > Logins area or why not?  That COULD be designed to track users and rights on various databases rather than a thing owned by each database....Thanks for your time.Gib

Failed to generate a user instance of SQL Server due to a failure in starting the process for the us

  
Hello,Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed. I'm using SQLServer2005 and VWD2010. Did the following below but to no avail. 1.) I have set SQL SERVER (SQLEXPRESS) built-in account to "Local System" at SQL Server Configuration Manager. Restart.  2.) Couldn't find the folder "SQLEXPRESS" at Vista c://Users/[username]/appdata/local/microsoft/microsoft sql server. Is there anything else I miss before doing my last resort? FORMAT my pc and hope it will work the next time.I'm using SQLServer2005 and VWD2010. I Did the following below but to no avail.1.) I have set SQL SERVER (SQLEXPRESS) built-in account to "Local System" at SQL Server Configuration Manager. Restart. 2.) Couldn't find the folder "SQLEXPRESS" at Vista c://Users/[username]/appdata/local/microsoft/microsoft sql server.Is there anything else I miss before doing my last resort? FORMAT my pc and hope it will work the next time.Thank You,-imperialx

Starting with SQL Server

  
Hi I wanted to get going with learning SQL sometime ago but had to postpone it but now got some time facilities; I like to have some assistannce. Let me give a brief on what I did earlier. I tried to download Visual Studio several times because I thought SQL also got shipped with it with it; unsuccessful; I tried to download SQL Server 2008 Express Edition earlier; unsuccessful; thinking the SQL Server 2005 files that were shipped with my computer could be the reason I uninstalled the same but I missed one file; later I tried SQL Server R2; it seems it has installed in my computer; I have been able to download Visual Basic 2008 Expres too. This is the list of Microsift programme files I have in the Control Panel; Compatibility Pack for the 2007 Office System (31.7 MB) .Net Framework 3.5 SP1 (27.8 MB) Office 2003 Web Components (20.4MB) Office 2007 Primary Interop Assemblies (7.23MB) Office Enterprise 2007 (626 MB) Office powerpoint Viewer (English) (50.8 MB) Small Business Connectivity Components (158 MB) Report Viewer Redistributtable 2008 SP1 (114MB) Silverlight SQL Server 2005 (37.4 MB) SQL Server 2008 R2 (590 MB) SQL Server 2008 R2 Native Client (2.90 MB) SQL Server 2008 Policies (983 KB) SQL Server 2008 Setup (English) (32.3MB) SQL Server 2008 Setup Support Files (21.6 MB) SQL Server Browser (8.99 MB) SQL Server Compact 3.5 SP2 ENU (3.39 MB) SQL Server Comp

Restoring Databases form SQL Server 2000 and SQL Server 2005 to SQL Server 2008 -Side by Side --he

  
Hi all I Installed SQL Server 2008 R2 in Server and I took backup of all the User databases backup from 2000 and 2005(two instance are running) Now I am doing restore the Databases,while I am restoring I am information icon in bottom of the restore window that is "The Full-Text Upgrade Option server property controls whether full-text indexes are improved,rebuild or reset" that means I have to upgrade full-text indexes or this just inforamtion.If I want find out whither Database using full-text how to check ? once I done this I have to move the users as well.Please dome body share the script you have.   Thanks in AdvanceSNIVAS

Best practices on moving SharePoint databases physically, while keeping them on the same SQL server?

  
I'd need to move the SharePoint 2010 databases (preferably all of them) with as little hassle as possibly from one partition to another. I tried once, and ended up with a broken SharePoint and had to recover from backups. What's the best practices for moving the databases without breaking SharePoint completely in the process? I'm guessing I need to shut down the SharePoint server for this... That's not impossible if needed.

Sharepoint Server 2007. Sharepoint Designer workflow not starting for one user only.

  

We have created a custom workflow in SPD that is attached to a document library within a MOSS 2007 teamsite.

The workflow is set to trigger when a new item is created in the document library.

Previously, the workflow has worked fine for all users but recently has stopped working for one user only.

For the problem user, what we are seeing is that when a new item is created in the document library, the attached workflow never starts.  There is no error, the workflow just does not get triggered.  However, if the problem user goes to an item in the document library and clicks on the workflow she can manually start it and it works fine with no error.

This user has the same permissions on the site as others who do not have any problem.

In the course of investigating this problem, we have temporarily increased the problem users permissions on the document library to full control (was contribute before) but this has had no effect on the problem.  Authentication is being done via Active Directory.  We have tried removing the user from the site and re-instating her but again this has no impact.

Does anyone have any idea how we could fix this problem or further debug it?


Automatic Stopping and Starting of SQL Server?

  

Hello:

I know how to manually go into the Control Panel Administrative Tools Services applet to stop and re-start SQL Server services.  But, is it possible to somehow program this service to automatically stop and re-start, say, at midnight each night so that temporary tables and other items get cleaned out and so that apps that depend on SQL will perform better during the business day?

childofthe1980s


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend