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


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

sql 2008R2 Express em rede

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

Ola pessoal  instalei o SQL Server 2008R2 Express em uma maquina com o Windows 7 ultimate

E to tendo dificuldade para deixar um banco de dados em rede

Primeira pergunta

  A versão do SQL serve 2008R2 Express da para colocar banco de dado em rede

Se a resposta for  sim  como que faço para habilitar o banco de dados na rede já  fiz tudo que sabia e segui alguma dicas postada em alguns fórum mais não funciona

Segunda pergunta

Tenho que configurar a minha maquina como servidor  ou quando instalo o SQL Server automaticamente ela já e


View Complete Post


More Related Resource Links

Access 2003 mdb file to SQL 2008r2 Express

  
I attempted to use 'Import Export Data' tool to import an Access 2003 mdb file into SQL Server 2008r2.  I didn't develop the Access file.  I get an 'Error 0xc0207015 - The data source column names must be unique' This is coming from one of the queries that accesses a few tables.  What is the easiest way to see which tables need to have a column changed or edit the query?  And also, too, how do I see whether other queries will have the same problem? Thanks,  Bill

Install App that uses .NET Framework 4 and SQL Server 2008R2 Express (with Tools) - what .NET Framew

  

I am a little confused about how to install my application.  Written in C# using VS 2010 and targeted for the .NET 4 Framework.  It also uses a SQL Server 2008 R2 database.

In my installer I install .NET 4 Framework if not already present on the host machine.

For SQL Server 2008 R2 (with Tools) I understood I need Installer 4.5 and Powershell 1.0.  The install of install of 4.5 installer goes ok but requires a reboot.  The install of Powershell says it needs .NET Framework 2 SP2 - even tho' .NET 4 is installed.

I decide to ignore this and carry on so manually install SQL Server 2008 R2 Express (with Tools).  It unpacks and complains it needs .NET Framework 3.5 SP1!

My application has to deploy to a disconnected machine installed in the cab of a logging harvester so I can't rely on automatic wwindows updates.

 

To deploy my app with SQL Server 2008 R2 (with Tools) do I need ...

  • .NET Framework 2.0 SP2 and
  • .NET Framework 3.5 SP1 and
  • .NET Framework 4

??

Wow??

I had presumed all I would would be .NET Framework 4 since it is "mostly" backwardly compatible.

Install time and complexity is HUGE is I need all three Frameworks.

 

Can someone please clarify for me?

Thanks

 

John

Error linking MS Access 2010 to SQL Express 2008R2

  

I've posted this question in a MS Access forum but nobody was able to figure out what the issue is.

 I am getting the following error when I try to link MS Access 2010 to a SQL Server Express 2008R2 table:
'idx_table name' is not a valid name. make sure it does not include invalid characters or punctuation and that is not too long.

Details:
- the table name is: italpasta-etp.etp.timehistory
- the connection: 64bit ODBC (test successful)
- I get the same error if I try to import the table
- both MS Access and SQL Server Express are new, 64bit installations (I don't know if that matters)

I tried changing the SQL table name to a single word (like "TEST") but it didn't make any difference.

Anyone came across a similar issue?
Any suggestion is appreciated.
Thank you.
Peter


Windows 2008R2 + MS SQL 2005 Express + "Synchronize" tool ? Where it is ...

  

Hello Everyone,

I just installed in a test setup a replication from SQL Server 2005 to SQL 2005 Express. Everything work fine. However, I like to schedule it to run ever hour. On the express machine, a Windows 2008R2, I cannot find the "Synchronize" tool (Normally in accessory folder). After looking online I ended up copying it from another machine. However, it does not work well.

 

Where is that tool in Windows 2008R2 ? I am doing something wrong ?

 

Thanks


Send Email from SQL Server Express Using a CLR Stored Procedure

  
Problem
One of the nice things about SQL Server is the ability to send email using T-SQL. The downside is that this functionality does not exist in SQL Server Express. In this tip I will show you how to build a basic CLR stored procedure to send email messages from SQL Server Express, although this same technique could be used for any version of SQL Server.

Solution
If you have not yet built a CLR stored procedure, please refer to this tip for what needs to be done for the initial setup.

Visual Web Developer 2010 Express "Copy Web Site" using different login

  

I created a site and am trying to grant another pesron access to upload changes to it without giving them my super-user login.


I made a login for her but I can't test whether it works or not because no matter how much I "disconnect" in the Copy Web Site page of VWD 2010, reconnecting to the same site always logs in as my superuser account without prompting me for a login again.

How do I test is the account it set up correctly before having her try to upload to it?    I want to force the login to remote site dialog to pop up again to test her account.

Any ideas?


connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly.

  

I dont have the SQL EXPRESS installed instead I have SQL Standard Edition.

 I have two SQL Server instances installed.

 1- UserLT (this is sql 2000)
2- UserLT\SQL2005 (this is SQL 2005 named instance)

But when i try to add a database to my VS website project I get the following error:

Connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly. please verify the installation of the component or download from the URL: go.microsoft.com/fwlink/?linkId=4925

I went in Tools>Opetions>DataBase tools>Data Connection>Sql Server Instance Name (blank for default)

and changed the "SQLEXPRESS" to "USERLT\SQL2005".

But I still get the same error message. Any ideas how i can resolve this issue?


Express Yourself: Encoding Videos Using Microsoft Expression Encoder 3 SDK

  

Video on the Web involves huge amounts of data. Learn the best way to manage and move that data with the help of Microsoft Expression Encoder 3.

Adam Miller

MSDN Magazine June 2010


Express Editions: Get a Lean, Mean Dev Machine with the Express Editions of Visual Basic and SQL Ser

  

The Express Editions of Visual Basic and SQL Server 2005 have lots of the features of the full-sized versions, but with a lot less of the overhead. Professional developer features such as full IntelliSense support, local debugger, Add Web Reference, and the improved Visual Data Tools will all be available in the Express products, so you don't have to leave your favorite features behind. In this article the author introduces you to these express editions and builds a sample app to get you started.

Brian A. Randell

MSDN Magazine September 2004


web sites made with visual webdeveloper express 2010

  

Good evening,

just a quick question, are there a lot of developers using  the express edition to make web sites, or is it limited to what you can do, and I would be  better getting the full edition visual studio 2010. I have been using dreamweaver, but I wanted to try my hand at asp.net, thx for any info you can offer.


VS2010 Express ASP.net and database file with SQL Authentication

  

Hi,

I have installed Visual Studio 2010 Express in my local system.

Steps
1. File->New Website
2.Open datbase explorer, right click on dataconnection
3.Select Create new connection
4.use Microsoft SQL Server Database file
5. Type new databse filename
6. Now i want to use SQL authentication which is not working
7.If we use windows authentication its wokring without any problem
8.But i need sql authentication to be used.
9.I have not installed SQL studio. I am only using the one which is packaged in VisualStudio 2010 SQLClient.

Let me know how can we create a new database file with userID and password. So that i can host it in other systems as well without any windows authentication.

Thanks and regards
Mahesh kotekar
http://mahesh.kotekar.com  


VS2010 Express ASP.net and database file with SQL Authentication - How to create database file with

  

Hi, I have installed Visual Studio 2010 Express in my local system.

Steps 1. File->New Website

 2.Open datbase explorer, right click on dataconnection

 3.Select Create new connection

 4.use Microsoft SQL Server Database file

5. Type new databse filename

6. Now i want to use SQL authentication which is not working

 7.If we use windows authentication its wokring without any problem

8.But i need sql authentication to be used.

 9.I have not installed SQL studio.

 I am only using the one which is packaged in VisualStudio 2010 SQLClient. Let me know how can we create a new database file with userID and password. So that i can host it in other systems as well without any windows authentication.  I know that VS2010 setup also installs the SQL client which is requiredto create and manage sql databse files/quries etc

 

i dont know the default userID and password for SQLauthentication. As the express setup did not asked any credentials while installing SQL components

 

Thanks and regards

 Mahesh kotekar

http://mahesh.kotekar.com


FLV file in Visual Web Developer Express 2008

  

I'm trying to embed a flv in my web page and I don't have a clue how to do it.

I downloded and installed ASPNetFlashVideo and the tools do not appear in my toolbox.

So if anyone has a work around it would be greatly appreciated.


CSS support in visual studio 2008 express edition

  

I have several css style sheets I want to work with.  I have copied them into the appropriate directory structure in my project.  The styles are applied correctly.

But the manage CSS styles tool bar on the left margin doesn't seem to work correctly.  At one point I had generated a style sheet and worked with it there, but now it not only can't find the one it generated, but the attach style sheet link doesn't respond at all, nor does anything in this bar.  Same deadness with the CSS Properties bar.  With or without a style sheet loaded in the editor -- a style sheet that is active in the project such that when I run it, the styles are applied.

VB version of studio, running on Vista home basic.


PS, the design mode works a lot better than the professional version I use in my day job on XP and server 2003.



Upgrading VS 2003 Project File to VB Express Edition 2005

  

Hi,

I downloaded some project from some site which is made in VS 2003. When I open its project file in Notepad I get following at first line Microsoft Visual Studio Solution File, Format Version 8.00. I don't have VS 2003 in my PC but I have VB 2005 and 2008 Express Edition. Now I wanted to upgrade that file but it is not doing. Can somebody help to upgrade it.


Need help uninstalling incomplete Visual Web Developer 2008 Express Edition with SP1

  

I need to get a list of programs/files that were installed when I was trying to install VWD 2008 so I can go through and remove them.  The installation did not actually install the main part of the program so I can't start with removing Microsoft VWD 2008 (a folder was created in Program files but it is empty.  I found this (below) but I'm not sure that it applies. I don't want to remove programs/files that are being used by other programs. (I can't just try to install again because there is not enough room on my hard drive)

Uninstalling Previous Versions of Visual Studio 2008

This article applies to pre-Release versions of Microsoft Visual Studio 2008. For 2005 version of this document, see Uninstalling Previous Versions of Visual Studio 2005.

For best results, Visual Studio 2008 should b

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