I'm new to SQL Server 2005 Express. I'm sure it's great but after successfully installing it on Vista, I don't know how to "connect" to the default "instance".
Can someone please point me to a online tutorial on connecting once installed... or please help me out with understanding this.
After that I think I can go forward with the msdn video tutorials.
Thanks in advance
Before page 12, step by step instructions work!
Then there is code for AllProducts.aspx that doesn't work if one inserts the code
into the DataTutorial project started on page 1. Yes I changed the name of the CodeFile!
The code given for AllProducts.aspx.cs doesn't compile.
I was doing better without the tutorial!
I can gleen out some concepts but that is all.
If that is all, why have a tutorial?
Hi folks, I'm new to Windows Mobile progamming, and new to this forum. Apologies in advance if I'm asking a boneheaded question, but I've done searches and can't find anything directly applicable to my problem.
I'm currently walking through the published MS tutorial in setting up an SQL Server 2005 Mobile application that subscribes to a publication on SQL Server 2005 to exchange information.
I've gotten almost all the way through... successfully set up the server components, creating the publication, etc. On the mobile side, I've been able run the cab files to install the SQL Mobile components and to create the project, add the reference to the dll, and instantiate an engine object. It compiles.
The step in the tutorial after that, though, where you specify the data source from the "data" menu, I've got a problem. When I try to use the "new connection" dialog from choosing the data connection, "MS SQL Server Mobile Edition" doesn't show up as a choice. I've tried choosing any of the other combinations, and in teh subsequent "Connection properties" section my database, SQLMobile (as in their sample) is available, but I get an error when I choose it and click OK. Clicking on "Test Connection" gives me a connection successful message.
My guess is that something about the Mobile server side components is not installed correctly on my development machine, but honestly I have no idea how to begin to fix it. Has anyone seen this problem before and know how to resolve it?
Your time and any knowledge sharing is greatly appreciated.
Thank you,
-Dana
Hello All.
i´m completely new to mssql2005 (or any mssql-server), but i have to install one on a MS W2k3 Enterprise Edition Server.
Now i have to setup a MS Project Server 2003
What I did:
Installed MS Sql2005
Setup SharePointServices 2.0 (incl. SP2)
Created a new Database
Created 2 different new Users
both users have the same permissions (nearly all AD and SQL)
When i start the Installation i allways receive the same Error:
Login failed for user 'mycompanyuser'. [Client: 192.168.123.122] = Thats the IP of the server i´m working on
Error: 18456, Severity: 14, State:6
The same error on SQL Server and Windows NT???
I really have no idea what i did wrong. i can login to AD with both users, etc. i checked all permissions...
thanks for any idea...
best greetings
markus
please mail me to: markus.fahnl@gmx.at
HI there... i'm really new to this, and i want to know if there is a tutorial of how to connect to sql database, display the data online, and run some queries....
thanks in advance
please e-mail me to hachemr@hotmail.com
Where can I find a good MDX tutorial ..
I am a beginner with analysis services
but got a job in which i have to create a cube and some mdx querires
Try this outRegards,Josephhttp://db2examples.googlepages.com
View 1 Replies View RelatedDo you know a good link (i.e. on msdn) that has a good tutorial for SSIS?
Thanks
Hey guys, while going thru the sql tutorial #5 on this website, I have run into an error. Am using, sql server management studio where it is required I attach a database, on adding the selected db, here is the error that I get, and i have no clue whatsoever on how I must proceed:
TITLE: Microsoft SQL Server Management Studio------------------------------
Attach database failed for Server 'parijat'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476
------------------------------ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Could not find row in sysindexes for database ID 7, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.Could not open new database 'MyCompany'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=602&LinkId=20476
------------------------------BUTTONS:
OK------------------------------
hi there! im new to MSSQL and i want to know if anyone of you knows a reliable website which teaches a detailed and in depth info on how to use mssql...
thanks!
I'm using VB to access MDBs, and now I want to expand my work to a SQL server. Does anyone know where someone of my needs can find a suitable tutorial?
Thanks in advence,
Chen
There's a tutorial (http://msdn2.microsoft.com/ms345296.aspx) on how you create a login in SQL Server. But when I type a new user name I get the error message that the name allready exists. But if I type a existing user name I get the error message that the user name or group couldn't be found.
View 3 Replies View RelatedHi all,
i'm looking for an article on how to use DataTypes of SQLServer in T-Sql script writing !!!?
As you know the Books-Online has limited example and i have trouble undertanding for example how to use Binary,varbinary Decimal,Float,real...in T-sql script
Could anyone showm me an instructive article on the net?
Thanks in advance.
I'm a coldfusion programmer that works with SQL Server databases. We have the opportunity to move our database from a shared sql server to a semi-private virtual machine with our own copy of sql server 2005. We'll all of a sudden be able to use more features of sql server including replication. We want to be able to keep several databases on the same server in sync so that we can have a production database and a development database that are identical.
I'm not a professional dba but I am willing to learn. Is there a good, straightforward tutorial about setting up and using replication out there that someone can recommend?
Many thanks!
Are there any good free online tutorials for T-SQL?
View 2 Replies View RelatedHi Forum-Members,
I was doing the Step by step tutorial "Developing a SQL Mobile Application with Visual Studio 2005 and SQL Server 2005". Link: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/med302_msdn_sql_mobile.asp
Doing it on Windows XP (as required by the tutorial) worked fine for me, doing it on a Windows Server 2003 installation failed, as the client could not connect to the SQL Server database.
Does anyone have experience stepping through the tutorial on a Windows Server 2003 machine?
Best Regards,
Tobias
Hello!Im trying to write SQL but I dont think that SQL is enough for me right now.I wants to write Stored Procedures, but I dont know how to... Is there any good tutorials you can recomend?
View 3 Replies View RelatedDo someone know good tutorial on web with examples for search data from SQL database?
View 2 Replies View RelatedHello all,
I have been trying to set up roles and security for my database using SQL Web Data Administrator(from Microsoft). Unfortunately, i am facing some difficulties to do it. Is there any link that explain how to manage these roles and security issues in the program.
Thanks
hi all,
could anybody send me the tutorial site for learning sql server...
especially in stored procedure,functions,triggers.
thanx in advance
hey!Im looking for a db tutoral which covers accessing a Microsoft SQL databaseon windows. I will be using VC++ if it matters. NO details just a basicintroduction!Oracle DB access using C++ is also of interest!Thanks!-- Majk
View 1 Replies View RelatedDoes anyone know of a good matrix tutorial which shows a finished report and how the choices for Page, Columns, Rows, and Details map to a finished report? Having a tough time wrapping my head around the direct impact, and for whatever reason, my sample data keeps triggering an "Out of memory" during preview mode.
View 2 Replies View RelatedAfter I complete the SSIS Tutorial Lesson 5 and try to run the package, I found there's no any rows inserted into the error output file. I'm sure that I'd followed all the procedures. Anybody help?
View 1 Replies View Related
One of the wonderful tutorials Microsoft done for SQL DBA/ Developers
If you are having hard time to understand SSIS Package. Please finish the entire tutorial to become Master on SSIS.In order to finish the entire tutorial you need to start from fresh installation of sample Database by Microsoft. Once finish all Tutorial you will be master on SSIS.Good luck.
Thanks
Faiz Farazi
MCDBA, MCSA
In Lesson1 of SSIS Tutorial, section "Running the Wizard to Create the Basic Package", is stated
"Specify the data source. You will use the Excel workbook, Customers.xls, as the data source..."
I have both AdventureWorks databases installed on my box as well as a host of samples but I can't find that file. Any pointers much appreciated.
TIA,
barker
Hello everyone, I've been using the tutorial located here.I am using Microsoft Visual Studio 8.0.50727.42, Microsoft SQL Server 2005, and Microsoft .NET Framework 2.0.50727 SP1.The tutorial uses the SQL Express version and I cannot get it to connect to the standard SQL Server 2005 version. I have used the website ConnectionStrings.com and the whitepaper located here and I wasn't able to get my web app talking to the database through many attempts.I am using a database in Microsoft SQL Server 2005 named SecurityTutorials. This is located on my local machine. There is a login named SecurityTutorials and a user in the SecurityTutorials database named SecurityTutorials who has default schema dbo, who owns the db_owner schema, and has role membership to db_datareader, db_datawriter, and db_ddladmin. The password of this user does match the password in the connection string in web.config, I have verified this multiple times.The problem comes when I open up the CreatingUserAccounts page of this tutorial. When I hit the button 'Create the User Account,' nothing happens. And no record is inserted into the database.Here is my web.config file (if you need any other files then please let me know and I can post them but it is my understanding that this is the only file responsible for the database connection):<?xml version="1.0"?><!-- Note: As an alternative to hand editing this file you can use the web admin tool to configure settings for your application. Use the Website->Asp.Net Configuration option in Visual Studio. A full list of settings and comments can be found in machine.config.comments usually located in WindowsMicrosoft.NetFrameworkv2.xConfig --><configuration> <appSettings/> <connectionStrings> <add name="SecurityTutorialsConnectionString" connectionString="Server=localhost;Database=SecurityTutorials;User Id=SecurityTutorials;Password=**********;" providerName="System.Data.SqlClient"/> </connectionStrings> <system.web> <membership defaultProvider="SecurityTutorialsSqlMembershipProvider"> <providers> <!--Add a customized SqlMembershipProvider --> <add name="SecurityTutorialsSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider" connectionStringName="SecurityTutorialsConnectionString" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" applicationName="SecurityTutorials" requiresUniqueEmail="true" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="7" minRequiredNonalphanumericCharacters="1" passwordAttemptWindow="10" passwordStrengthRegularExpression=""/> </providers> </membership> <!-- Set compilation debug="true" to insert debugging symbols into the compiled page. Because this affects performance, set this value to true only during development. --> <compilation debug="false" /> <!-- The <authentication> section enables configuration of the security authentication mode used by ASP.NET to identify an incoming user. --> <authentication mode="Forms"> <forms slidingExpiration="true" timeout="60" /> </authentication> <machineKey decryption="AES" validation="SHA1" decryptionKey="1513F567EE75F7FB5AC0AC4D79E1D9F25430E3E2F1BCDD3370BCFC4EFC97A541" validationKey="32CBA563F26041EE5B5FE9581076C40618DCC1218F5F447634EDE8624508A129" /> <!-- The <customErrors> section enables configuration of what to do if/when an unhandled error occurs during the execution of a request. Specifically, it enables developers to configure html error pages to be displayed in place of a error stack trace. <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm"> <error statusCode="403" redirect="NoAccess.htm" /> <error statusCode="404" redirect="FileNotFound.htm" /> </customErrors> --> </system.web></configuration>Note: The password is an actually password. Not sure if it'd be a good idea to post that here, even though it is a test database.Thank you all in advance for your advice!
View 1 Replies View RelatedHi,
I want the tutorial for developing Integration Service for copying the database from Oracle 9i to SQL Server 2005.
If anybody knows then pls give me the steps..
Thanx in advance.
Hi,
Can someone suggest me a simple and nice tutorial that can explain T-SQL with examples.
Plizzz....
Regards..,
Aazad
While building the expression for the property: ConnectionString, I am facing an issue. The expression, I am trying to assign is '@[User::varFileName]'. When I clicked on the 'Evaluate Expression' button, the above expression is not returing any value in 'Evaluated Value' window. Please respond we have a solution.
View 3 Replies View Relatedi am asked to develop a web application where i have to display reports in a seperate window from a hyperlink .i have to display the report in grid format and show a pie chart within the report layout .
i need to give user credential like print,save the report in excel or doc format and email report.
can anybody give the links for the best tutorial to achieve my purpose.
thanks
sally
Hi all,
Is there any tutorial to learn how custom transformation component works? maybe a blog, pdf or something...
Specifically, i need to learn how to generate an output column composed from 3 input columns. The problem is i dont know how to set the column value... anyone have some sample code?
Thanks!
The 6:th of march Sql server data tools for Visual Studio 2012 was released.
[URL]
I seem to be unable to install this using the link provided on the blog page. I'm getting a "Same architecture installation" error. Running on the machine is Visual Studio 2012 Premium & Sql Server 2012 (64bit).
why I'm getting this installation error.
Is there a beginners tutorial for SQL Server Management Studio Express that explains how to add a database to the server?
thanks
Canning