The SQL Server Express Edition

[AmjiBhai]

The SQL Server Express Edition is a freely-downloadable and -distributable version .

www.microsoft.com/sqlserver

Is this worth trying?
A word of advice please .

 

[Abraham Andres Luna]

Yes I would advise you should download that freebie. I have used it to manage databases. It is easy to use and provides many features. If you have any specific questions please let me know.

https://giftedart.gear.host/
https://www.indiehackers.com/user/abeLuna

 

[AmjiBhai]

Thank you very much. I am a layman and i am getting ready to setup a test environment. I have windows 7 server cd, three I4 lenovo notebooks one of these will be server and two will be clients . i intend to connect them using a rj45 cables , i will use an ethernet hub/switch. The first thing which i wish to achieve is to have DHCP so that ip addresses are automatically assigned as soon as a machine enters into the network .thereafter i will proceed to sequel server setup.

Am i on the right track. Please let me know if i am missing something .

 

[Abraham Andres Luna]

That is a fine setup you are thinking of running. When you said "Windows 7" I had to look it up, I guess you meant 2007? Anyway, it sounds like you will be able to figure this all out, and if not, we are here to help.

 

[AmjiBhai]

That is a fine setup you are thinking of running. When you said "Windows 7" I had to look it up, I guess you meant 2007? Anyway, it sounds like you will be able to figure this all out, and if not, we are here to help.

Yes i mean windows 2007.
Thanks for your support. BTW what is WINS protocols server, is it essential to be installed on server, or just enabling DHCP will be sufficient ?

 

[Abraham Andres Luna]

what is WINS protocols server

Here is a link that describes the WINS Protocol: https://docs.microsoft.com/en-us/pr.../it-pro/windows-server-2003/cc728457(v=ws.10)

Windows Internet Name Service (WINS) is a name resolution service that maps NetBIOS names to IP addresses in networks that use NetBIOS over TCP/IP (NetBT). As such, the primary purpose of WINS is to support clients that run older versions of Windows and applications that use NetBIOS.

 

[AmjiBhai]

Here is a link that describes the WINS Protocol: https://docs.microsoft.com/en-us/pr.../it-pro/windows-server-2003/cc728457(v=ws.10)

Windows Internet Name Service (WINS) is a name resolution service that maps NetBIOS names to IP addresses in networks that use NetBIOS over TCP/IP (NetBT). As such, the primary purpose of WINS is to support clients that run older versions of Windows and applications that use NetBIOS.

Ok, so i should just focu

 

[Abraham Andres Luna]

Ok, so i should just focu

You didn't finish your reply, but you shouldn't install the WINS protocol unless you are using Windows versions that are older than 2000.

 

[AmjiBhai]

You didn't finish your reply, but you shouldn't install the WINS protocol unless you are using Windows versions that are older than 2000.

I am sorry I just noted that my previous reply was left complete...strange...Anyway I will now focus on DHCP as my first milestone...will let you know as soon its achieved. I look forward to exciting experience sharing (particularly with SQL Server) in the coming couple of weeks.

Thanks for your help.
Kind regards
Amjad

 

[AmjiBhai]

OMG it's windows 7 professional not windows 2007 server...
Now what to do.
Can we configure one laptop as a server and remaining two as it clients. All having Windows 7 professional.?

I have got a tp-link 8-port gigabit desktop switch.

 

[AmjiBhai]

following is config of my three laptops.

 

[AmjiBhai]

I am encouraged with the following note on a forum:


empiresoftware May 26, 2015 at 7:36 PM

Empire Software Services is an IT service provider.

yes you could problably do that I have a windows 7 homegruop set up at my business and it works great

• 
  

 

[AmjiBhai]

Hi,

my tp-link 8 port gigabit switch is connected to my laptop.
Now I need help for TCP/IP configuration...

following is the screen shot.

Please let me have a slight push as this is a crucial stage...

 

[AmjiBhai]

Thank you very much Abraham, I managed to setup LAN, now I am proceeding to install SQL Server 2012...
Why 2012? because it allows OS windows 7 Professional

 

[AmjiBhai]

Hi ,

I have successfully installed LAN and installed SQL Server 2012

 

[AmjiBhai]

What is the latest Service Pack of SQL Server Express.
I am on SP1

 

[Abraham Andres Luna]

I am glad you got things setup correctly. I think that because you are using Windows 7 Pro you won't be able to use the latest version of SQL Express. But here is a link to SQL Express 2014 SP2: https://www.microsoft.com/en-us/download/details.aspx?id=53167
That version would probably work better for you.

 

[AmjiBhai]

Hi friends,

Yes Abraham ! in future I may need to get SP2. but for the moment I am happy, its great. I used ADO to create database, test created tables, test dropped tables, populated data into my tables and developed a demo and showed it to my superiors, and everyone is happy.

So far so good, but now I feel I must move towards Sequel server Admin, I want to see the physical tables I created and want to browse all those objects..
I look forward to your kind advice.

Thanks & regards..
Amjad

 

[AmjiBhai]

Can you please tell me how to get the command line?

I followed the following guideline but ended-up at a mysterious terrifying error message says...
Your SQL Server Installation is either corrupt or has been tampered with (Error getting instance ID from name.)

Nevertheless I am able to use my database and tables.

Please help...
Thanks a lot for your on-going support

 

[Abraham Andres Luna]

You should use Microsoft SQL Server Management Studio to connect and edit your database.